Excel Is Fun

Excel Magic Trick 1272

February 20, 2017 0

DESCRIPTION Max Value for Each Day Of The Week: AGGREGATE Function (2 Methods) Learn how to find the max value for each day of the week using the Excel 2010 or later function AGGREGATE. See […]

Excel Is Fun

Excel Magic Trick 1271

February 16, 2017 0

DESCRIPTION Extract Top 20 Values & Dates: Formula, Array Formula or Power Query? Learn how to extract Top 20 values and dates for those values using Formulas when there are no duplicates, Array Formula for […]

Dueling Excel

Dueling Excel 121

November 30, 2016 0

DESCRIPTION MIN and MAX Between Two Dates For Each Region See Mr Excel and excelisfun use two methods to calculate MIN and MAX Between Two Dates For Each Region (Minimum value and maximum value with […]

Dueling Excel

Dueling Excel 111

October 7, 2016 0

Slowest Time That Is Within 2 Seconds Of The Fastest DESCRIPTION See Mr Excel and excelisfun use two methods to find the Slowest Time That Is Within 2 Seconds Of The Fastest: 1) Mr Excel: […]

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