### Excel Magic Trick 1274

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

### Dueling Excel 127

DESCRIPTION Adding After & Before Dash: Array Formula or VBA? See Mr Excel and excelisfun use two methods to solve this very difficult adding problem: you must add numbers from a column of text strings [Read More >>>]

### Excel Magic Trick 1255

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

### Excel Magic Trick 1244

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

### Excel Magic Trick 1234

DESCRIPTION VLOOKUP to 36 Different Tables: Helper Column w LOOKUP & Expandable Range Learn how to use a helper column formula to lookup a discount rate in 36 different tables: (00:11) Introduction to problem we [Read More >>>]

### Dueling Excel 102

Remove Duplicate Records Based On Partial Text in a Cell DESCRIPTION See Mr Excel and excelisfun use two methods to Remove Duplicate Records Based On Partial Text in a Cell using: 1. Formula with SUBSTITUTE, [Read More >>>]

### Excel Magic Trick 1224

Which Similar Array Formula? Compare Number of Array Operations DESCRIPTION Learn how to build similar formulas and compare the number of array operations in order to decide which formula might be most efficient: (00:08) Problem [Read More >>>]

### Dueling Excel 94

Lookup Data In Text String & Extract Data From Text String DESCRIPTION See Mr Excel and excelisfun use two methods to: 1. Lookup Data In Text String & Extract Data From Text String in order [Read More >>>]

### Dueling Excel 87

Positive Subtotals Only: PivotTable or SUMIFS DESCRIPTION See Mr Excel and excelisfun use two methods to add only the subtotals that are positive (ignore negative Subtotals using PivotTable Pivot Table or SUMIFS or SUMPRODUCT functions. [Read More >>>]

### Excel Magic Trick 1199

Formula to Extract Everything After Last Space: Two Formula Solutions DESCRIPTION See how to use Formula to Extract Everything After Last Space: (00:08) Problem Setup (01:05) Formula with TRIM, RIGHT, SUBSTITUTE, REPT, LEN and LEN [Read More >>>]