Sorry. I will use =RANDBETWEEN(1,1000) in 30 cells


"Gaurav" wrote in message
...
Hi All,

If I use RANDBETWEEN function to generate random samples, how do I make
sure that units are not repeate?

For example-

I have 1000 units and I have to generate 30 samples. I will use
RANDBETWEEN(1,30) in 30 cells. How do I make sure that the numbers are not
repeated and all the samples are unique?

Thanks in advance for any help.