View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gary''s Student
 
Posts: n/a
Default Random List Generation

In B1 thru B500 enter:

=rand()

Then sort cols A&B by B.
Then select the first 25 items in column A
--
Gary's Student


"carl" wrote:

I have a list of 500 dates in ColA. Is there an easy way to generate a random
list of 25 dates.

Thank you in advance.