Deleting both duplicate records
 

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

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