Photo Gallery

Excel Magic Trick 309: Partial Text Match: Why 2^15?
Excel Magic Trick 930: Mixed Numbers In Formulas: Plus or No Plus, Excel Stills Knows!
Excel Magic Trick 1211: Array Operations on Different Size Arrays & CHISQ.TEST Function
Excel Magic Trick 1029: DON'T Use IFERROR, Use IF and Logical Test If Possible...
Excel Magic Trick 1120: Is Item in All Three Lists?
Excel Magic Trick 913: Select From Drop Down and Pull Data From Different Sheet
Excel Magic Trick 1000: Lookup Last Partial Text Item using SEARCH and LOOKUP functions
Excel Magic Trick 1122: Repeat Row Headers Vertically For Each Day Activity Exists: Array Formula
Excel Magic Trick 1031: Four Way Lookup Formula To Deliver Multiple Items From 1 of 2 Lookup Tables
Excel Magic Trick 699: VLOOKUP Mixed Number & Letter Partial Text Extract For Lookup Value
Excel Magic Trick 992: Partial Text Criteria for a Number, SUMIF Won't Work
Excel Magic Trick 1001: Lookup Biggest Number After Partial Text Lookup, Many Duplicates