This worked great! Thank you very much.

"T. Valko" wrote:

Try it like this:

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

--
Biff
Microsoft Excel MVP


"TotallyConfused" wrote in
message ...
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.