### Dueling Excel 149

July 5, 2017

DESCRIPTION See Mr Excel and excelisfun have an epic back and forth duel that shows many ways to add or count with OR Criteria: (00:15) PivotTable (01:12) Excel Table feature with a Total Row with […]

### Excel Magic Trick 1285

April 6, 2017

OR Criteria & AND Criteria for Max & Min Calculations (5 Examples) DESCRIPTION Learn how to calculate the MIN and MAX values when there is complex criteria that mixes OR Logical Tests and AND Logical […]

### Highline Excel 2013 Class Video 26

March 10, 2017

DESCRIPTION Topics in this video: 1. Is Item In List 2 also in List 1? Use MATCH and ISNUMBER. Comparing a prospective customer sales phone list to the companies master customer list. 2. Sort Dialog […]

### Excel Magic Trick 1255

December 12, 2016

DESCRIPTION Formula to Convert Text Dates With Missing Year & Extra Spaces To Real Dates Learn how to Convert Text Dates With Missing Year & Extra Spaces To Real Dates (Serial Number Dates) with a […]

### Excel Magic Trick 1248

November 17, 2016

DESCRIPTION Add or Count Case Sensitive Contains Criteria: ISNUMBER, FIND, SUMPRODUCT Learn how to add with Case Sensitive Contains Criteria EXACT & SUMPRODUCT. This video builds on the last video, Trick 1246: Counting with Case […]

### Excel Magic Trick 1244

November 3, 2016

DESCRIPTION Transform GDP Data Set: Advanced Filter with Formula Criteria wins! From Bill Szysz at YouTube, see how to use a Formula in Criteria area of Advanced Filter to extract data based on three conditions […]

### Excel Magic Trick 1242

October 27, 2016

DESCRIPTION Transform Large Data Set to Final GDP Report: TTC, MATCH, Filter & Format Learn how to Take Large Data Set with Country Economic Data for the years 1970 to 2013 and filter, delete and […]

### Excel Magic Trick 1226

September 1, 2016

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 98

August 31, 2016

Extract & Lookup Number When Table Of Numbers Is In A Single Cell DESCRIPTION See Mr Excel and excelisfun use two methods to: 1. Check whether Numbers In Cell C2 Also In F2? 2. Mr […]

### Excel Magic Trick 1221

August 15, 2016

Dynamic Chart to Plot Daily Changes in Meter Readings DESCRIPTION Learn how to create a dynamic chart that updates when daily meter readings are entered into a table (00:10) Problem Setup (00:50) IF function and […]