Is there a way to randomly select rows in Excel?

J

JE McGimpsey

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.
 
S

Samantha

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....
 
J

JE McGimpsey

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.
 
S

Samantha

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...
 
Top