Dueling Excel

Dueling Excel 56

Copy Formula Down, Have Range Move Across DESCRIPTION See Mr Excel and excelisfun create formulas that can be copied down across the rows and have the range in the function move across the columns. See [Read More >>>]

Dueling Excel

Dueling Excel 035

3 Way Lookup INDEX or OFFSET function? DESCRIPTION See Mr Excel and excelisfun do a three way lookup. Compare a method that uses INDEX, MATCH and OFFSET function to a second method that uses INDEX [Read More >>>]

Dueling Excel

Dueling Excel 034

Dynamic Range for Adding Three Methods DESCRIPTION See Mr Excel and excelisfun add a range of values that is dynamic in two directions. The range of values to add changes depending on what you select [Read More >>>]

Dueling Excel

Dueling Excel 022

Conditional Formatting VBA or OFFSET? DESCRIPTION See Mr Excel use VBA code for Conditional formatting and see excelisfun use the OFFSET, MOD and ROWS functions to do Conditional Formatting. WORKBOOKS

Excel Is Fun

Excel Magic Trick 1117

DESCRIPTION See how to calculate an average for 12 different samples when numbers are in a single column: (00:25) PivotTable (average in one condition/criteria) (02:22) AVERAGEIFS Function (average in one condition/criteria) (05:37) AVERAGE, ROWS and [Read More >>>]

Excel Is Fun

Excel Magic Trick 1091

DESCRIPTION See how to count the number of items entered into the row that corresponds to the first occurrence of each Group Number using: 1) INDEX, MATCH and COUNTA functions to “lookup a row” for [Read More >>>]