### Dueling Excel 58

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

### Excel Magic Trick 1179

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

WORKBOOKS

### Excel Magic Trick 1164

Average Score After Subtracting Two Lowest: SMALL & Array or AVERAGEIF? DESCRIPTION See how to calculated the average for quiz scores after subtracting the two lowest (00:08) Problem Setup (00:22) Status Bar Trick (00:50) Convert [Read More >>>]

### 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 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 Magic Trick 1118

DESCRIPTION See how to Extract Word That Occurs Most Frequently: (00:07) MODE calculation for text. (00:57) COUNTIFS function for basic mode calculation (01:38) INDEX, MODE and MATCH function (with function argument array operation) to extract [Read More >>>]

### Highline Excel 2013 Class Video 24

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