Excel Is Fun

Excel Magic Trick 1313

August 14, 2017 0

DESCRIPTION Learn how to create an Array Formula to Create Sorted Unique List in Cell. This is a huge complicated formula that requires the Excel 2016 function TEXTJOIN. There are many interesting formula elements in […]

Excel Is Fun

Excel Magic Trick 1310

August 3, 2017 0

DESCRIPTION Calculate Minimum Value Greater Than Zero. See the functions: SMALL, COUNTIFS and AGGREGATE (LARGE). WORKBOOKS

Excel Is Fun

Excel Magic Trick 1301

June 26, 2017 0

DESCRIPTION Learn how to create an array formula to show a sorted list of modes in a single cell. See the Functions: TEXTJOIN, INDEX, SMALL, MODE.MULT, COUNT, ROW, INDIRECT. Learn about difference (and history) between […]

Excel Is Fun

Highline Excel 2013 Class Video 24

February 24, 2017 0

Getting Top 5 Values With LARGE And Bottom 5 With SMALL DESCRIPTION Topics in this video: 1. Getting Top five values with LARGE and ROWS 2. Getting Bottom five values with SMALL and ROWS WORKBOOKS

Dueling Excel

Dueling Excel 103

September 16, 2016 0

Find Missing Numbers In A Series DESCRIPTION See Mr Excel and excelisfun use two formula methods to Find Missing Numbers In A Series: See Mr Excel use the functions IF, ISNA, VLOOKUP, ROW, and SMALL […]

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

Excel Is Fun

Highline Excel 2016 Class 02

July 24, 2016 0

Excel Fundamentals: Comprehensive Formula Lesson (15 Examples) DESCRIPTION In this video learn about: (00:13) Introduction (01:09) Excel’s Golden Rule (04:31) Look at list of Formula Types and Formula Elements (06:29) Number Formula Examples (08:24) Text […]

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

Dueling Excel

Dueling Excel 58

January 6, 2016 0

Sorting Formula For Biggest Sales and Sales Rep Names with Ties DESCRIPTION See Mr Excel and excelisfun create formulas for sorting biggest to smallest (descending) numbers that can deal with ties, then sort the sales […]

Excel Is Fun

Excel Magic Trick 1179

November 23, 2015 0

Calculate Mean, Median and Mode From Data Set DESCRIPTION See how to: (00:30) Mean using AVERAGE function (02:15) Median using MEDIAN function (03:17) Mode using MODE.MULT, SMALL and IFERROR functions