Photo Gallery

Excel Magic Trick 809: Diff Workbook: Advanced Filter Extract  Unique Records & Adding W Criteria
Excel Magic Trick 1142: Get Every Other Row with Formula: INDEX and ROWS*2
Excel Magic Trick 824: Two Way Lookup With More Than One Lookup Table Same or Different Sheets
Extract Data From Excel Cell. 4 Different Methods! Excel Magic Trick 1664
Excel Magic Trick 1178: Conditional / AND Percentage: PivotTable Slicer, COUNTIFS or DCOUNTA?
Excel Magic Trick 1073: Excel Tables & Dynamic Data Extraction Array Formulas, AGGREGATE or SMALL
Excel Magic Trick #179: Are All Four Word The Same?
Spilled Array Formulas Make Excel Life Easy. Compare Two Lists Extract Items Excel Magic Trick 1750
Excel Magic Trick 915: What Exactly Does VLOOKUP Do? What Is Purpose Of VLOOKUP? 9 Examples
Excel Magic Trick 1134: IF or VLOOKUP function for Assigning Categories w/ Excel Formula 8 Examples
Excel Magic Trick 757: Two Lookup Values & 2 Lookup Columns? Great Formula INDEX & MATCH
Excel Magic Trick 1137: Excel & PowerPivot DAX Formula: Approximate Match Lookup Without VLOOKUP