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

On Aug 26, 2:10*pm, Dendy wrote:
=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