Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Deleting multiple rows through a formula
So does anyone know a formula that will allow me to delete multiple rows of
re-occuring data in a spreadsheet. For example, I have a spreadsheet of 10,000 lines, with multiple mobile numbers on it. I need to only have one of each mobile number and delete the remaining rows where the mobile has been repeated? |
#2
|
|||
|
|||
Mike
you may be able to use the advance filter where can select unique records only. select data filter advanced filter select copy to another location then in list range box enter range to filter in the copy to box enter a free column select unique records only then ok then just delete original column Tina "mike_vr" wrote: So does anyone know a formula that will allow me to delete multiple rows of re-occuring data in a spreadsheet. For example, I have a spreadsheet of 10,000 lines, with multiple mobile numbers on it. I need to only have one of each mobile number and delete the remaining rows where the mobile has been repeated? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find duplicate rows then deleting them | Excel Worksheet Functions | |||
Multiple rows of data on a single axis (charting) | Charts and Charting in Excel | |||
How get the rows indicated by one formula to become the input for. | Excel Worksheet Functions | |||
Counting rows based on criteria in multiple cells | Excel Discussion (Misc queries) | |||
Can I set a filter for a merged column across multiple rows and o. | Excel Worksheet Functions |