Dueling Excel

Dueling Excel 010

January 20, 2015 1

Turn Column / Row Upside Down DESCRIPTION See Mr Excel and excelisfun invert a range (Turn a range of cells upside down) with two different INDEX formulas. See the functions: INDEX ROW, ROWS, COLUMNS. See […]

Dueling Excel

Dueling Excel 009

January 19, 2015 0

Data In Columns VBA or Clipboard? DESCRIPTION See Mr Excel and excelisfun take a table of data and create a column of values that can be used with the Statistical Data Analysis Excel Add-in. Mr […]

Dueling Excel

Dueling Excel 008

January 18, 2015 0

Top 10 Filter Trouble DESCRIPTION See Mr Excel and excelisfun try to deal with the Top 10 Filter with Two Criteria Trouble. Mr Excel solves the problem with Advanced Filter and a Criteria Formulas. Excelisfun […]

Dueling Excel

Dueling Excel 007

January 17, 2015 0

Reverse Lookup VBA or Formula? DESCRIPTION See Mr Excel and excelisfun complete a Reverse Lookup (find value inside table and then retrieve Column and Row header. Mr Excel uses Excel VBA code (Macro) excelisfun uses […]

Dueling Excel

Dueling Excel 006

January 15, 2015 0

Get Last Value In Row DESCRIPTION See Mr Excel and excelisfun try and retrieve the last value in a row. See the INDEX, OFFSET, LOOKUP and MAX functions. WORKBOOKS

Dueling Excel

Dueling Excel 005

January 6, 2015 0

Horizontal Subtotals DESCRIPTION See Mr Excel and excelisfun try and create Horizontal Subtotals for a data set. See the IF, SUM and SUMIF functions as they try to solve this very difficult problem. Also see […]

Dueling Excel

Dueling Excel 004

January 5, 2015 0

Comparative Charts DESCRIPTION See Mr Excel and excelisfun create charts to compare data values: 1) Bar Chart 2) Stacked Column Chart 3) Trendline to predict future data values WORKBOOKS

Dueling Excel

Dueling Excel 003

January 4, 2015 0

Wildcard Count DESCRIPTION See Mr Excel and excelisfun demonstrate three methods to count words that contain the letter D: 1) Filter & SUBTOTAL 2) Table & SUBTOTAL 3) COUNTIF and criteria syntax Count with criteria […]

Dueling Excel

Dueling Excel 002

January 3, 2015 0

Decrease Values By 35% DESCRIPTION See Mr Excel and excelisfun demonstrate two methods to subtract 35% from a column of values: Mr Excel: Create formula for remaining percentage (1 + decrease), copy remaining percentage, Paste […]

Dueling Excel

Dueling Excel 001

January 2, 2015 0

Two 2 Way Lookup DESCRIPTION See Mr Excel and excelisfun demonstrate two methods to do a two way lookup on a table array: Mr Excel: MATCH and INDEX functions in one formula to retrieve a […]