Photo Gallery

Excel Magic Trick 976: Excel Two Way Lookup - 11 Examples (2 Way Lookup)
Excel Conditional Format Row, Column & Intersecting Cell -  Excel Magic Trick 1572
Excel Magic Trick 977: Lookup First Non Empty Cell In A Range, Lookup Last Number In A Range
Excel Magic Trick 1118: MODE for Text Values, Extract Word That Occurs Most Frequently
Excel Magic Trick 993: Conditional Formatting Row Where Last Three Numbers In ID Equal 123
Excel Magic Trick 750: 7 Days Past Due Conditional Formatting & Logical Formula
Excel Magic Trick 787: Conditional Formatting Basic To Advanced (30 Examples)
Excel Magic Trick 1012: Automatically Add All Subtotals In A Column (6 Methods)
Excel Magic Trick 1013: MIN IF, MAX IF, MINIF, MAXIF (6 Examples) MAX MIN calculation w 1 criteria
Excel Magic Trick 1001: Lookup Biggest Number After Partial Text Lookup, Many Duplicates
Excel Magic Trick 991: Formula To Create Sequential Numbers 1.1, 1.2, 1.3, 2.1, 2.2, 2.3, ...
Excel Magic Trick 167p1 IF function formula: 12 Examples!