Excel Is Fun

Excel Magic Trick 1226

September 1, 2016 0

DESCRIPTION Compare 2 Lists, Extract Items In List 2 That are NOT in List 1 (6 Examples) Learn how to Compare 2 Lists, Extract Items In List 2 That are NOT in List 1: (00:12) […]

Dueling Excel

Dueling Excel 78

May 18, 2016 0

Extract Top Two Customers In Each Industry with Formula (2 Examples) DESCRIPTION See Mr Excel and excelisfun Extract Top Two Customers In Each Industry with 2 array Formulas that use the AGGREGATE, IF, COLUMNS, INDEX, […]

Excel Is Fun

Excel Magic Trick 1198

March 28, 2016 0

Median for Each Quarter Using AGGREGATE Function DESCRIPTION See how to calculate Median for Each Quarter Using AGGREGATE Function (00:08) Problem Setup (00:49) Defined Names for ranges using keyboard for Create Names From Selection: Ctrl […]

Excel Is Fun

Excel Magic Trick 1190

February 1, 2016 0

Formulas To Extract Unique List County Numbers & List Zip Codes Horizontally DESCRIPTION See how take two columns of county numbers and kip codes and show unique list of county codes vertically, and then for […]

Dueling Excel

Dueling Excel 54

December 9, 2015 0

Approximate Lookup To Return Multiple Items DESCRIPTION See Mr Excel and excelisfun create solution to do an approximate lookup to return multiple items. See VBA solution and array formula solution. Also see Excel 2010 AGGREGATE […]

Dueling Excel

Dueling Excel 050

November 11, 2015 0

#N/A errors SUMIF or AGGREGATE? DESCRIPTION See Mr Excel and excelisfun create formulas to add a column of numbers and ignored the #N/A error: SUMIF function or AGGREGATE function? WORKBOOKS

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 1137

June 25, 2015 0

Excel & PowerPivot DAX Formula: Approximate Match Lookup Without VLOOKUP DESCRIPTION See how to (00:08) Intro. (01:21) Approximate Match with VLOOKUP. (02:20) Approximate Match with AGGREGATE (to simulate logic that is present in DAX formula). […]

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 1111

March 9, 2015 0

DESCRIPTION See how to extract items in List 2 that are also in List 1 using a great array formula from Exceli Adam at YouTube that uses the functions IF, INDEX, MATCH and AGGREGATE. MATCH […]