How can I randomize a set of data?

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

Guest

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!
 
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.
 
You must log in or register to reply here.

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

Similar Threads

Data Randomization 2
Arranging words in a column in dictionary wise order 5
Windows 10 One of my previous builds is experiencing random, multiple BSODs 9
Random Numbers 2
17 random numbers between 1 to 65 8
Can a column of numbers be set to mix up in random order 1
Urgent Help Needed please 3
Using =RANDBETWEEN(a,b) in a paers of a whole colume 1

Back
Top