VBA to identify duplicates

[helpexcel]

Hi - I have a huge list in column B. I want to go through the list and put "Duplicate" in column C next to items that are the same. Thanks for the help.

 

[mikerickson]

put =IF(COUNTIF(B:B, B1)>0,"Duplicate","") in C1 and drag it down.

 

[helpexcel]

All blanks. Is that because the data is text?

 

[mikerickson]

Actually, that is very odd, since as written (with the error) it should return "duplicate" for every cell.
Change the 0 to a 1 and I\it should work fine with text. (Unless it is dates or numbers formatted as text).
Did you drag it down so the formula in C2 is =IF(COUNTIF(B:B, B2)>1,"Duplicate","")