Photo Gallery

Excel Magic Trick 1122: Repeat Row Headers Vertically For Each Day Activity Exists: Array Formula
Excel Magic Trick 1142: Get Every Other Row with Formula: INDEX and ROWS*2
Excel Magic Trick 1170: VLOOKUP To Different Table In Each Column: CHOOSE & COLUMNS Functions
Excel Magic Trick 1120: Is Item in All Three Lists?
Excel Magic Trick 762: Two Way Lookup from Multiple Tables & Lookup Tables Sorted Descending
Excel Magic Trick 1114: Formula For Sequential & Repeating Numbers: 18400 1, 18441 1, 18442 2...
Excel Magic Trick 1152: Formula or Power Query: Cost Report When Product IDs Don’t Match
Excel Magic Trick 1211: Array Operations on Different Size Arrays & CHISQ.TEST Function
Excel Magic Trick 1102: VLOOKUP with Three Different Tables to Rank Movies, VLOOKUP & IFERROR
Excel Magic Trick 1161:   F4 Key To Repeat Last Action
Excel Magic Trick 1172: Multiple Dot Plots With Single Formula, INDEX, COUNTIFS & REPT
Excel Magic Trick 994: Min Digit From A Cell: MIN or AGGREGATE Array Formula?