Excel Is Fun

Excel Magic Trick 1187

January 11, 2016 0

Formula to Lookup Every 5th Item In a Column, INDEX and ROWS functions DESCRIPTION See how to create a formula to Lookup Every 5th Item In a Column using INDEX and ROWS functions.

Excel Is Fun

Excel Magic Trick 1184

December 21, 2015 0

Formula to Create Alpha Numeric Series X20, X25, X39… DESCRIPTION See how to create formula to create Alpha Numeric Series X20, X25, X39… using ROWS function. See the ROWS function and an expandable range to […]

Dueling Excel

Dueling Excel 036

August 12, 2015 0

VLOOKUP w Approximate Match & Unsorted Table DESCRIPTION See Mr Excel and excelisfun do a VLOOKUP for an approximate match when the table is not sorted. See Mr Excel create the exact match for his […]

Excel Is Fun

Excel Magic Trick 1143

July 16, 2015 0

Extract Content From Non-Empty Cells: Filter or Array Formula? DESCRIPTION See how to use Filter and Array Formulas to Extract Content From Non-Empty Cells: (00:39) Filter, Copy, Paste (01:26) Excel 2010 or later formula with […]

Excel Is Fun

Excel Magic Trick 1142

July 13, 2015 0

Get Every Other Row with Formula: INDEX and ROWS*2 DESCRIPTION See how to create a formula to Get Every Other Row with Formula using INDEX function and ROWS function. See how to increment the numbers […]

Dueling Excel

Dueling Excel 022

May 22, 2015 0

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 1128

April 28, 2015 0

DESCRIPTION See how to create an automated Accounting Ageing Accounts Receivable Reports On Multiple Sheets With Array Formula, Excel Table Feature and Formula Table Nomenclature (Structured References): (00:16) Overview of end result: Automatic Ageing Reports […]

Excel Is Fun

Excel Magic Trick 1123

April 23, 2015 0

DESCRIPTION See how to… Create a formula To Create A List of Dates For Month. Change the start date and the list updates. See the functions, EOMONTH, DAY, IF, ROWS. WORKBOOKS

Excel Is Fun

Excel Magic Trick 1117

April 17, 2015 0

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 […]

Excel Is Fun

Excel Magic Trick 1116

April 16, 2015 0

DESCRIPTION (00:37) INDEX and MATCH when we have a two fields (columns): Sample Number and Number To Be Averaged. Use MATCH to lookup first occurrence of each sample number with Exact Match, which only finds […]