Excel Function Help please

[TotallyConfused]

Please help with this function. I am using the following function to
identify dupes in my list. "=IF(COUNTIFI(B$1:B$1000,B1)>1,"DUP,"NO DUP")".
However, I would like the function to keep once instance of the dup and
identify everything else. When I filter on "DUP", only the dups will be
deleted. Does this make sense? How can I do this please? Thank you.

 

[T. Valko]

Try it like this:

=IF(COUNTIF(B$1:B1,B1)=1,"NO DUP","DUP")

 

[TotallyConfused]

This worked great! Thank you very much.

Try it like this:

=IF(COUNTIF(B$1:B1,B1)=1,"NO DUP","DUP")

 

[T. Valko]

You're welcome. Thanks for the feedback!