Removing ALL duplicate entries

[Ray]

Hi,

How can I remove ALL instances of duplicate entries.

Let say I have a list in Column A and there are two
entries that contains the same value. I want BOTH entries
to be deleted.

Thank You. I appreciate all your help.

 

[Frank Kabel]

Hi
one way:
- add a helper column (e.g. column B) and enter the following formula:
=IF(COUNTIF($A$1:$A$1000,A1)>1,"X","")
- copy this down for all rows
- apply a filter ('Data- Filter - Autofilter') and filter with column B
- delete all rows with 'X' in column B

 

[Ray]

Thank You Frank, I appreciate your help.
Saved me a ton of time. =D

 

[frankp23]

Thanks I was randomly surfing the postings earlier tonight and happened to
read your solution. I just now found a problem in my work, rummaged back
through postings found yours and it worked great for my problem
It feels like de ja vu synchronicity
Thanks again