Photo Gallery

Excel Magic Trick 930: Mixed Numbers In Formulas: Plus or No Plus, Excel Stills Knows!
Excel Magic Trick 1116: Lookup Every Third Item or Lookup Every "Nth" Item, 3 Formula Methods
Excel Magic Trick 1043: Count Unique Numbers in Column with Empty Cells and Text (Mixed Data)
Excel Magic Trick 1190: Formulas To Extract Unique List County Numbers & List Zip Codes Horizontally
Excel Magic Trick 699: VLOOKUP Mixed Number & Letter Partial Text Extract For Lookup Value
Excel Magic Trick 1211: Array Operations on Different Size Arrays & CHISQ.TEST Function
Excel Magic Trick 360: Part 3: Return Multiple Items From One Lookup Value for Row w Formula
Excel Magic Trick 1029: DON'T Use IFERROR, Use IF and Logical Test If Possible...
Excel Magic Trick 1012: Automatically Add All Subtotals In A Column (6 Methods)
Excel Magic Trick 1314: Array Formula To Create Sorted Unique List with Mixed Data
Excel Magic Trick 1156: Count with Two Conditions / Criteria From Non-Proper Data Set (2 Methods)
Excel Magic Trick 1309: Extract Unique List and List in Single Cell: TEXTJOIN Array Formula