Photo Gallery

Excel Magic Trick 1149: Dynamically Sum by Category without VLOOKUP Helper Column (2 methods)
Excel Magic Trick #148: Dynamic List from Table #3
Excel Magic Trick 549: Dynamic Data Validation List Drop-Down  OFFSET or Table Feature?
LET Function Advanced Array Formula for Dynamic Cross Tabulated Report. Excel Magic Trick 1681.
Excel Magic Trick 746: Payback Rule Dynamic Single Cell Array Formula LOOKUP function Array Magic
Excel Magic Trick 1073: Excel Tables & Dynamic Data Extraction Array Formulas, AGGREGATE or SMALL
Excel Magic Trick 688: Lookup All Values In Expanding Dynamic Row and then Add
Excel Dynamic Arrays & Conditional Formatting for Spilled Arrays (Excel Magic Trick 1525)
Excel Magic Trick 1145: Create Random Data Set with Formulas: 4 Unusual Formulas
Excel Magic Trick 1012: Automatically Add All Subtotals In A Column (6 Methods)
Excel Magic Trick # 146 part 1: Dynamic List from Table #1
Excel Magic Trick 1094: Wildcards for Sheet References and INDIRECT function