Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I have a worksheet with some unique records and some duplicates. I want to be
able to find the duplicates and delete both of these records, not leave one of them as a unique record. We've spent most of this afternoon trying and failing to figure out how to do it non-manually... |
#2
![]() |
|||
|
|||
![]()
Hi
Try the duplicate option in EasyFilter http://www.rondebruin.nl/easyfilter.htm After you use begin with "duplicate" and select delete rows -- Regards Ron de Bruin http://www.rondebruin.nl "ruth_austin50" wrote in message ... I have a worksheet with some unique records and some duplicates. I want to be able to find the duplicates and delete both of these records, not leave one of them as a unique record. We've spent most of this afternoon trying and failing to figure out how to do it non-manually... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Deleting specific records | Excel Discussion (Misc queries) | |||
Deleting specific records from a column | Excel Discussion (Misc queries) | |||
deleting duplicate records in a mail merge | Excel Discussion (Misc queries) | |||
How to delete duplicate records when I merge two lists (deleting . | Excel Worksheet Functions | |||
Duplicate records in Excel | Excel Discussion (Misc queries) |