Excel Is Fun

Excel Magic Trick 1346

DESCRIPTION See how to use formulas to extract records from a Master Table to Sub Tables on Each Excel Worksheets for each product in the Master Table: (00:17) Introduction. Look at Dynamic End Result Solution. [Read More >>>]

Excel Is Fun

Excel Magic Trick 1321

DESCRIPTION See how to use (00:14) Intro (01:36) MIN & MAX & IF & SEARCH solution (Any Version of Excel) (07:49) INDEX & MATCH & LEFT solution (Any Version of Excel) (08:35) AGGREGATE & ISNUMBER [Read More >>>]

Excel Is Fun

Highline Excel 2013 Class Video 30

Custom Number Formatting & Text Functions, (33 Examples) DESCRIPTION Topics in this video: 1. 23 Examples of Custom Number Formatting. 2. Custom Number Formatting For Unit Price for Invoice. 3. Three TEXT function examples for [Read More >>>]

Excel Is Fun

Excel Magic Trick 1278

Extract Colour From Description (Text String) Learn how to Extract Colour From Description (Text String) using LOOKUP & SEARCH functions and the Big Number 2^15 in an Array Formula. WORKBOOKS

Excel Is Fun

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

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 Is Fun

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 Is Fun

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 Is Fun

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

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