### Dueling Excel 134

March 22, 2017

DESCRIPTION Merge Product and Sub-Product Text; VBA or Wild INDEX Formula See Mr Excel and excelisfun use two methods to take a table of product names, each with 6 sub-products, and unwind the table to […]

### Excel Magic Trick 1279

March 16, 2017

DESCRIPTION Learn how to create a New Running Count (Cumulative Count) Formula After Each Zero Value using the IF and SUM functions. Trick from Bill Szysz at YouTube. See that the SUM Function ignores Text […]

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

### Dueling Excel 131

March 1, 2017

DESCRIPTION See Mr Excel and excelisfun use two methods to Prevent VLOOKUP from Returning a Zero: 1. Alter the lookup table so there are not empty cells 2. Custom Number Formatting 3. IF and VLOOKUP […]

### Excel Magic Trick 1274

February 27, 2017

DESCRIPTION Learn how to avoid long formula with multiple IF Functions by using the lookup functions: VLOOKUP or LOOKUP. Also see a “Partial Text Lookup” Situation where we have to lookup just part of a […]

### Excel Magic Trick 1260

January 9, 2017

DESCRIPTION VLOOKUP Returns Zero when Lookup Table Contains Empty Cell? 3 Fixes. Learn how to prevent VLOOKUP from returning a zero when it sees an empty cell in the lookup table: (00:12) Problem setup. (00:49) […]

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

### Dueling Excel 121

November 30, 2016

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 118

November 9, 2016

DESCRIPTION Formula To Calculate Commissions for Four Scenarios See Mr Excel and excelisfun use two methods to calculate the commissions based on the fact that the two sales people may both be at work for […]