Photo Gallery

Excel Magic Trick 659: Advanced Filter Using Formula Criteria to Extract Sample Data
Excel Magic Trick 1116: Lookup Every Third Item or Lookup Every "Nth" Item, 3 Formula Methods
Excel Magic Trick 755: Extract Records For Invoices 30 Days Past Due -- Advanced Filter & MACRO
Excel Magic Trick 1119: Conditional Format Date when 44 Days Have Passed
Excel Magic Trick 1244: Transform GDP Data Set: Advanced Filter with Formula Criteria wins!
Excel Magic Trick 186.5 Advanced Filter Data Extract 2 criteria
Excel Magic Trick 995: Formula: Amount To Increase Sales By To Get To Next Commission Bracket.
Excel Magic Trick 850: Conditional Format More Than 24 Hours (3 Examples)
Excel Magic Trick 809: Diff Workbook: Advanced Filter Extract  Unique Records & Adding W Criteria
Excel Magic Trick 778: INDEX & MATCH Lookup Functions Beginning To Advanced (18 Examples)
Excel Magic Trick 1104: Add with 6 Criteria (AND and OR Criteria) with Criteria/Data Mismatch
Excel XLOOKUP Function – Comprehensive Lessons – 27 Examples - Excel Magic Trick 1600