Thread: How do you avoid duplicates when using the randbetween function?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
daddylonglegs
 
Posts: n/a
Default 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

Reply With QuoteReply With Quote