Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]() |
#2
![]() |
|||
|
|||
![]()
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. |
#3
![]() |
|||
|
|||
![]()
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.... "JE McGimpsey" wrote: 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. |
#4
![]() |
|||
|
|||
![]()
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. In article , "Samantha" wrote: 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.... |
#5
![]() |
|||
|
|||
![]()
Awesome!! Thank you SO much!
"JE McGimpsey" wrote: 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. In article , "Samantha" wrote: 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.... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Updating rows - Excel Formula or Something Else? | Excel Worksheet Functions | |||
How do I import data into Excel that exceeds 70000 rows? | Excel Discussion (Misc queries) | |||
How do I increase the limit on the number of import rows in Excel | Excel Discussion (Misc queries) | |||
Using excel to select only matching images... | Excel Discussion (Misc queries) | |||
How do I remove blank rows in Excel? | Excel Discussion (Misc queries) |