View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Hannie1004
 
Posts: n/a
Default How can I randomize a set of data?

I have a list of over 3000 companies with associated data in alphabetical
order. However, I only want to extract a list of 500 companies but randomly.
Is there anyway to get excel to randomize the order of the 3000 companies so
that I can just take the top 500 companies from the randomized list? Thank
you!