Photo Gallery

Excel Magic Trick 1016: Randomly Do A Two Way Lookup INDEX, VLOOKUP and RANDBETWEEN
Excel Magic Trick #17: Randomly Generate Whole Numbers
Excel Magic Trick 1116: Lookup Every Third Item or Lookup Every "Nth" Item, 3 Formula Methods
Excel Magic Trick #16: Randomly Generate Numbers (0-1)
Excel Magic Trick 1001: Lookup Biggest Number After Partial Text Lookup, Many Duplicates
Excel Magic Trick 1018: CEILING Function To Round Up To The Nearest $1000 Increment
Excel Magic Trick #19: Randomly Generate Words
Excel Magic Trick 1092: Count Double, Triple, Quadruple, Quintuple Occurrences in Excel
Excel Magic Trick 1145: Create Random Data Set with Formulas: 4 Unusual Formulas
Excel XLOOKUP Function โ€“ Comprehensive Lessons โ€“ 27 Examples - Excel Magic Trick 1600
Excel Magic Trick 1149: Dynamically Sum by Category without VLOOKUP Helper Column (2 methods)
Excel Magic Trick 315: SUMIF Only Accept Ranges, Not Arrays