I'd add a helper column to do this. Let's say your data is in B2:B1000. In
your helper column, put this

=countif(B$2:B$1000,B2)

And copy to the end.
I'd then use autofilter to find all values of the helper column that are
greater than 1.
--
HTH,
Barb Reinhardt



"Pat Jones" wrote:

Hi;

I have about 8000 cells of which 800 are duplicates. I want to find all the
dupes and delete BOTH copies of them. Can that be done and if so, how ?


Thanks;

Pat