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" <[email protected]> wrote in message
news:[email protected]...
>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...