See John McGimpsey's site for instructions on resolving this problem

http://www.mcgimpsey.com/excel/udfs/randint.html


Gord Dibben MS Excel MVP

On Tue, 26 Aug 2008 16:16:20 -0600, "Gaurav"
wrote:

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.