View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bernie Deitrick Bernie Deitrick is offline
external usenet poster
 
Posts: 5,441
Default How do I get random numbers from a certain range?

Assuming your numbers are in A2:A469...

In B2:B469, enter =RAND() and then sort A and B based on B, and take the top
64 (A2:A65)

OR: you can use formulas to pull a different set of 64 each time you
re-calc, which may not be what you want.

HTH,
Bernie
MS Excel MVP


"Random numbers" <Random wrote in message
...
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?