Duplicates Excel 2000

[Dendy]

=IF(NOT(G2=G3), "No Duplicate")

I am using the above formula with a huge list. I have false on one of the
duplicates but would like to have false on both duplicates as I want to sort
all the false ascending to remove them at one time.

Thanks Linda

 

[Pete_UK]

Try it with this:

=IF(COUNTIF(G:G,G2)>1,"Duplicate","unique")

then copy down. No need to sort the list to get rid of the duplicates
- apply Autofilter to the column with the formula and choose Duplicate
from the filter drop-down. Then highlight all the visible rows and
click on Edit | Delete Row. Choose All from the filter drop-down to
see your remaining Unique values.

Hope this helps.

Pete

 

[JLatham]

Use COUNTIF instead, comparing individual entries in G to the entire list.
Assuming your huge list goes from row 2 to 295, then try this as the formula
in row 2 and fill down:
=IF(COUNTIF(G$2:G$295,G2)=1,"No Duplicate")