Photo Gallery

Excel Magic Trick 291: Add Nums Associated w Codes From String
Excel Magic Trick 1201: Conditional Format Product With No Sales (5 Examples)
Excel Magic Trick 1032: Add Record Count Column To Filtered Table (Fix SUBTOTAL Filter bug)
Excel Magic Trick 1140: VLOOKUP, TEXT & DOLLAR functions To Create Dynamic Finance Test Text Labels
Excel Magic Trick 991: Formula To Create Sequential Numbers 1.1, 1.2, 1.3, 2.1, 2.2, 2.3, ...
Excel Magic Trick 1170: VLOOKUP To Different Table In Each Column: CHOOSE & COLUMNS Functions
Excel Magic Trick 995: Formula: Amount To Increase Sales By To Get To Next Commission Bracket.
Append Two Number Columns and Sort. Excel Magic Trick 1682.
Excel Magic Trick 1035: Calculate Median with 1 condition with AGGREGATE & PERCENTILE.INC function
Excel Magic Trick 289: LEN & SUBSTITUTE functions Counting Tricks
Excel Magic Trick 992: Partial Text Criteria for a Number, SUMIF Won't Work
Excel Magic Trick 1012: Automatically Add All Subtotals In A Column (6 Methods)