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!

How can I randomize a set of data?
 

Use and adjacent column of cells.

Put =rand()
in each cell
sort by this column
Copy the top 500 and paste elsewhere.

Delete the helper column
and resort your data.

Hannie1004 wrote:

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!

--

Dave Peterson