How do you avoid duplicates when using the randbetween function?
 

I am trying to use the rand or randbetween function to select random samples,
but I keep receiving duplicate numbers. For example, I have a list of 70
samples but only want to select 25. I type in the formula and then drag it
down 25 cells, but some of those cells have the same number. How do I make
them unique?

Thanks!

How do you avoid duplicates when using the randbetween function?
 

If you put the formula

=RAND() in A1 and copy down to A70 then in B1

=RANK(A1,A$1:A$70)

and copy down to B25 this should give you 25 different integers between
1 and 70


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=512953

How do you avoid duplicates when using the randbetween function?
 

Take a look he

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


In article ,
Monica wrote:

I am trying to use the rand or randbetween function to select random samples,
but I keep receiving duplicate numbers. For example, I have a list of 70
samples but only want to select 25. I type in the formula and then drag it
down 25 cells, but some of those cells have the same number. How do I make
them unique?

Thanks!