View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default Random Number Selection

Put the list in column A and in B1 enter:

=RAND() and copy down

then sort columns A & B by column B. This will shuffle the numbers in
column A.


Just pick the top 20 in column A.
--
Gary''s Student - gsnu200767


"Work.Work.Work" wrote:

I need to randomly select 20 numbers from a list of 10k. How would I be able
to do this use the Random Generator?