Last week, during a training session, I quickly needed to set up a demo worksheet with some dummy data. The RANDBETWEEN function came to my rescue and let me enter 24 random numbers in seconds!


After typing the headings in, I positioned my cursor in B2 and typed =RANDBETWEEN(2000,5000) and pressed Enter

This enters a random number into the cell. The number will be a whole number and will be no lower than 2000 and no higher than 5000

I then copied the formula across to column G and down to row 5.

Be aware that every time you open the file, change the contents of ANY cell or perform the Undo command, in fact whenever you perform an operation that causes the worksheet to recalculate, all cells containing RANDBETWEEN are recalculated.