Is there a way to randomly select rows in Excel?

  • Thread starter Thread starter Guest
  • Start date Start date
Could you share a little bit more information about what you're trying
to accomplish? Simply selecting rows (multiple rows at once, or one at a
time?) doesn't do much.
 
I have a list of 13,000 contacts that I need to cut down to 10,000 - I need
to randomly delete 3,000 of them....
 
One way:

In an empty column, enter

=RAND()

and copy down 13000 rows. Choose Data/Sort and sort on that column.
Delete rows 10001 and higher.
 
Awesome!! Thank you SO much!

JE McGimpsey said:
One way:

In an empty column, enter

=RAND()

and copy down 13000 rows. Choose Data/Sort and sort on that column.
Delete rows 10001 and higher.
Click to expand...
 
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

In excel can you randomly select lines from another tab to post? 1
Can Excel randomly pick one winner out of 100 contest entries? 4
Random Samples 1
Select a random sample 2
Random select entries 2
Random selection method 3
randomly select numbers 2
Randomize rows in Excel? 2

Back
Top