Photo Gallery

Excel Magic Trick #107: Array Formula For Monthly Sales
Excel Magic Trick 746: Payback Rule Dynamic Single Cell Array Formula LOOKUP function Array Magic
Excel Magic Trick 1152: Formula or Power Query: Cost Report When Product IDs Don’t Match
Excel Magic Trick 1326: Conditionally Format Text Modes: PivotTable, Array Formula or Power Query?
Excel Magic Trick #137: Array Syntax for USA & Norway
Excel Magic Trick 1211: Array Operations on Different Size Arrays & CHISQ.TEST Function
Excel Magic Trick 1073: Excel Tables & Dynamic Data Extraction Array Formulas, AGGREGATE or SMALL
Excel Magic Trick 1122: Repeat Row Headers Vertically For Each Day Activity Exists: Array Formula
Excel Magic Trick 1009: Lookup 3 Different Arrays From 3 Different Tables: VLOOKUP, CHOOSE, INDEX
Excel Magic Trick 1012: Automatically Add All Subtotals In A Column (6 Methods)
Excel Magic Trick 677: AVERAGE Last 3 Scores -- Mr Excel Message Board Array Formula
Excel Magic Trick 1291: Reverse Lookup Array Formula to Score Myers-Briggs Test