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

Excel Is Fun

Excel Magic Trick 1224

August 25, 2016 0

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