Excel Is Fun

Excel Magic Trick 1295

May 11, 2017 0

DESCRIPTION Learn how to create random transaction description codes for products by randomly looking up a row from a product lookup table with the INDEX and RANDBETWEEN functions and then join them with a dash […]

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 […]

Dueling Excel

Dueling Excel 026

June 3, 2015 0

Randomize Between 2 Dates DESCRIPTION See Mr Excel and excelisfun create random dates between upper and lower dates using the 4 different formulas that use functions such as RANDBETWEEN, RAND, INT and DATE. See formulas […]

Dueling Excel

Dueling Excel 011

February 22, 2015 0

DESCRIPTION See Mr Excel and excelisfun create a formula that will randomly select a name from a list of names without having the list of names sitting in cells. See the functions INDEX, RANDBETWEEN, INT, […]