View Detailed Profile
Excel Magic Trick 1172: Multiple Dot Plots With Single Formula, INDEX, COUNTIFS & REPT

Excel Magic Trick 1172: Multiple Dot Plots With Single Formula, INDEX, COUNTIFS & REPT

Download

Excel Magic Trick 1142: Get Every Other Row with Formula: INDEX and ROWS*2

Excel Magic Trick 1142: Get Every Other Row with Formula: INDEX and ROWS*2

Download

Multiple Discount Lookup Tables!?!? LOOKUP & SWITCH Come to The Rescue. Excel Magic Trick 1831

Multiple Discount Lookup Tables!?!? LOOKUP & SWITCH Come to The Rescue. Excel Magic Trick 1831

Download

Excel Magic Trick 1174: Two Lookup Values For VLOOKUP? How Do I Do That? (6 Methods)

Excel Magic Trick 1174: Two Lookup Values For VLOOKUP? How Do I Do That? (6 Methods)

Download

Excel Magic Trick 762: Two Way Lookup from Multiple Tables & Lookup Tables Sorted Descending

Excel Magic Trick 762: Two Way Lookup from Multiple Tables & Lookup Tables Sorted Descending

Download

Excel Magic Trick #237: ROUND to Digit or Multiple

Excel Magic Trick #237: ROUND to Digit or Multiple

Download

Excel Magic Trick 1031: Four Way Lookup Formula To Deliver Multiple Items From 1 of 2 Lookup Tables

Excel Magic Trick 1031: Four Way Lookup Formula To Deliver Multiple Items From 1 of 2 Lookup Tables

Download

Excel Magic Trick 1001: Lookup Biggest Number After Partial Text Lookup, Many Duplicates

Excel Magic Trick 1001: Lookup Biggest Number After Partial Text Lookup, Many Duplicates

Download

Excel Magic Trick 1232: VLOOKUP to 36 Different Tables: Power Query Transforms 36 Tables Into 1

Excel Magic Trick 1232: VLOOKUP to 36 Different Tables: Power Query Transforms 36 Tables Into 1

(00:10) Introduction to problem we want to solve and look back to

Excel Magic Trick 892: Add Numbers Between 2 Dates w Multiple Criteria from Multiple Workbooks

Excel Magic Trick 892: Add Numbers Between 2 Dates w Multiple Criteria from Multiple Workbooks

Download

Excel Magic Trick 1152: Formula or Power Query: Cost Report When Product IDs Don’t Match

Excel Magic Trick 1152: Formula or Power Query: Cost Report When Product IDs Don’t Match

Download

Excel Magic Trick 1189: Extract Color From Description Create Revenue by Color PivotTable, 2nd Take

Excel Magic Trick 1189: Extract Color From Description Create Revenue by Color PivotTable, 2nd Take

Download

Excel Magic Trick 992: Partial Text Criteria for a Number, SUMIF Won't Work

Excel Magic Trick 992: Partial Text Criteria for a Number, SUMIF Won't Work

Download