Thread: How do I get random numbers from a certain range?
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gary''s Student Gary''s Student is offline
external usenet poster
  
Posts: 11,058
Default How do I get random numbers from a certain range?
Put your values in B1 thru B468.

In A1 enter:
=RAND() and copy down

In C1 thru C64 enter:

=VLOOKUP(LARGE(A$1:A$468,ROW()),$A$1:$B$468,2,FALS E)
--
Gary''s Student - gsnu200908


"Random numbers" wrote:

I have 468 unique numbers and need to select, at random, 64 numbers that do
not repeat. How do I get Excel to do this?
Reply With QuoteReply With Quote