Data Randomization

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I asked this question before but it wasn't answered correctly
So i will pose the question again in a different way.
i have a spreadsheet of 3000 company names with associated data
for example...
column A - company name (text) - alphabetical order descending
column B - numbers
I want to sort the list (text - company names) randomly to take the stats of
only 500 companies but randomly chosen. Is there anyway to automatically
scatter column A randomly to accomplish this.
Thanks
 
Put the formula...
=RAND()
in a column running down the list of 3000
Sort on the column that you put the Rand formual in...ensuring that you are
encompassing the entire range of your data.
You can sort Ascending or Descending. It doesn't matter, it's random :O>.
Take the top 500 in the list.

HTH,
 
Thanks SO much... i get it now. I got the same response previously but didn't
understand. Thanks a bunch!
 
Back
Top