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!
|