generating random numbers

[Tim]

Try the randbetween function. i.e. =RANDBETWEEN(1,500).
This will give you an integer between 1 and 500 each time.

 

[Biff]

Hi Tim,

RANDBETWEEN is also prone to return duplicates.