Photo Gallery

Excel Magic Trick 741: Avoid Errors & Blanks In Chart Using Formulas & Defined Name Dynamic Ranges
Excel Magic Trick 740: Avoid Errors & Blanks In Chart Using Filter
Excel Magic Trick 1152: Formula or Power Query: Cost Report When Product IDs Don’t Match
Excel Magic Trick 1201: Conditional Format Product With No Sales (5 Examples)
Excel Magic Trick 1001: Lookup Biggest Number After Partial Text Lookup, Many Duplicates
Excel Magic Trick 687: Exclude Values Less Than Zero From Non-Contiguous Ranges - Amazing!
Excel Magic Trick 1040: Formula To Extract & Sort A Unique List Of Numbers, No Empty Cells Or Text
Excel Magic Trick 1029: DON'T Use IFERROR, Use IF and Logical Test If Possible...
Excel Magic Trick #129: More than 7 Nested IF functions
Excel Magic Trick 1147: Incorrect Formula To Calculate Retirement Year
Excel Magic Trick 1181: Formula to Count Cells with 4 or More Characters: COUNTIFS & SUMPRODUCT
Excel Magic Trick 1118: MODE for Text Values, Extract Word That Occurs Most Frequently