Tricks to Create Random Data, Random Dates etc.

Tricks to Create Random Data, Random Dates etc.

Shishu Pal Shishu Pal Apr 24, 2019 1851 0

Tricks to Create Random Data, Random Dates etc.

Tricks to create random data, random dates etc.

Random numbers, text, dates, decimal numbers etc are highly useful for a Six Sigma trainee who is working on projects. Here is the explanation.

1. Random Numbers =RANDBETWEEN(100,170)

2. Random Dates =RANDBETWEEN(DATE(2011,2,14),DATE(2012,8,27))

3. Random Text

Put the text as given below from Cell No A1 to A8

BA
B.Com
MA
M.Com
MBA
Sr Sec
BSC
MSC

And then use the following formula

=INDEX($A$1:$A$8,RANDBETWEEN(1,8))

It can be used horizontally or vertically.

4. Generating Random decimal nos using RAND function

=RAND()

2 THOUGHTS ON “TRICKS TO CREATE RANDOM DATA, RANDOM DATES ETC.”