Dueling Excel

Dueling Excel 040

September 9, 2015 0

VLOOKUP to 3 Different Lookup Tables (3 table_arrays) DESCRIPTION See Mr Excel and excelisfun show how to do a VLOOKUP to 3 different tables using these tricks: 1) INDIRECT and CHOOSE 2) CHOOSE alone 3) […]

Excel Is Fun

Excel Magic Trick 1145

July 23, 2015 0

Create Random Data Set with Formulas: 4 Unusual Formulas DESCRIPTION See how to: (00:08) Overview of Different data Types (01:02) FORMULA 1: Create Random Serial Number Dates with RANDBETWEEN and actual Serial Numbers (02:10) Keyboards […]