Excel Is Fun

Excel Magic Trick 1346

December 21, 2017 0

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

Excel Is Fun

Excel Magic Trick 1321

September 25, 2017 0

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

Excel Is Fun

Highline Excel 2013 Class Video 30

April 7, 2017 0

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

Excel Is Fun

Excel Magic Trick 1278

March 13, 2017 0

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

February 27, 2017 0

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

Dueling Excel

Dueling Excel 127

February 1, 2017 0

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

Excel Is Fun

Excel Magic Trick 1255

December 12, 2016 0

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

Excel Magic Trick 1244

November 3, 2016 0

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

Excel Magic Trick 1234

September 29, 2016 0

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

Dueling Excel

Dueling Excel 102

September 14, 2016 0

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