Dueling Excel

Dueling Excel 036

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 [Read More >>>]

Excel Is Fun

Excel Magic Trick 1143

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 [Read More >>>]

Excel Is Fun

Excel Magic Trick 1142

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 [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 1128

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 [Read More >>>]

Excel Is Fun

Excel Magic Trick 1123

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

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 1116

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 [Read More >>>]

Excel 2013 PowerPivot Basics

Excel 2013 PowerPivot Basics 07

DESCRIPTION See how to: (00:17) Calendar Table in Diagram View with no Calculated Fields (00:58) Format Date Column (01:08) Create Calculated Column #01: Month Number using MONTH function. (01:53) Create Calculated Column #02: Month Name [Read More >>>]

Excel Is Fun

Excel Magic Trick 1114

DESCRIPTION See how to create formula for Sequential & Repeating Numbers: 18400 1, 18441 1, 18442 1, 18443 2, 18444 2, 18445 2, 18446 3…. See formula that uses the functions ROWS, INT and the [Read More >>>]