Removing Duplicates

[ajones2]

I have a column of data, and another column that may contain some information from the original column. I'd like to know if there is a way to search for a match in the second column, and either display a match or remove it from Column A.

[dilipandey]

HI ajones2,

Welcome to the forum.
Supposing your original column A and another column is B, you can include a formula in column C as "=IF(ISNUMBER(MATCH(B1,A:A,0)),"duplicate","unique")" and drag it down till you have data.

Regards,
DILIPandey
<click on below * if this helps>

[FDibbins]

Hi ajones2 and welcome to the forum

a variation on this will highlight your duplicates...

=IF(COUNTIF(C:C,C1)>1,"Duplicate","Unique")

adjust ranges as needed