### Dueling Excel 133

March 15, 2017

DESCRIPTION See Mr Excel and excelisfun use two methods to sum the three biggest values that match three criteria (3 conditions) 1. Advanced Filter and LARGE and MAX value 2. SUM and LARGE functions with […]

### Highline Excel 2013 Class Video 24

February 24, 2017

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

### Excel Magic Trick 1271

February 16, 2017

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 88

July 27, 2016

Highlight Cumulative Top 70% DESCRIPTION See Mr Excel and excelisfun use two methods to Highlight Cumulative Top 70%. Two long winded methods to highlight, not top 70% values, but the values that make up 70% […]

### Highline Excel 2016 Class 02

July 24, 2016

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 78

May 18, 2016

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 58

January 6, 2016

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

October 31, 2015

WORKBOOKS

### Excel Magic Trick 1132

June 8, 2015

Extract and Sort Numbers Greater Than Zero with Formula DESCRIPTION See how to Extract and Sort Numbers Greater Than Zero With Formula using COUNTIF, LARGE, and IF functions. WORKBOOKS

### Excel Magic Trick 1128

April 28, 2015

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