Photo Gallery

Excel Magic Trick 972: Empty Cell or Null Text String in Formulas: Counting Formulas
Excel Magic Trick #207: Business Math Word Problem Setup
Excel Magic Trick 1260: VLOOUP Returns Zero when Lookup Table Contains Empty Cell? 3 Fixes.
Excel Magic Trick 1189: Extract Color From Description Create Revenue by Color PivotTable, 2nd Take
Excel Magic Trick 849: Extract Records For Week With Formula that works in Excel 2003, 2007, 2010
Excel Magic Trick 1155: IF Function: Checking For Empty Cells (5 Methods)
Excel Magic Trick 1029: DON'T Use IFERROR, Use IF and Logical Test If Possible...
Excel Magic Trick #127: Count Less Than 70% of Max
Excel Magic Trick 977: Lookup First Non Empty Cell In A Range, Lookup Last Number In A Range
Excel Magic Trick 1096: Extract Date from Middle of Description, Better Formula
Excel Magic Trick 1152: Formula or Power Query: Cost Report When Product IDs Don’t Match
Excel Magic Trick 1190: Formulas To Extract Unique List County Numbers & List Zip Codes Horizontally