find duplicates and unique (single)

[udprocks]

Dear Ninja's,

Hope going all well.

I Have a query again like i have an excel sheet with contact numbers and that is not in sequence like if one same no is in cell b1 then second in b19 or something like this, i just want to show in next column infront of number it will show me duplicate except one unique that should be blank. if possible


Many thanks in advance.

Also i have attached a sample sheet with expected result.

 

[Luke M]

If you want the keep the last instance as the unique:
=IF(COUNTIF(B2:B$73,B2)>1,"Duplicate","")
To keep first instance as unique:
=IF(COUNTIF(B2:B$2,B2)>1,"Duplicate","")

 

[udprocks]

If you want the keep the last instance as the unique:
=IF(COUNTIF(B2:B$73,B2)>1,"Duplicate","")
To keep first instance as unique:
=IF(COUNTIF(B2:B$2,B2)>1,"Duplicate","")

Thanks a lot luke sir, exactly what i want. thanks again.