Data Randomization

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
 
G

Guest

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,
 
G

Guest

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top