Deleting Duplicates

Hi there,

Please could you help me by writing a formula that will highlight duplicates. I want to use the supplier code (column D) as the search criteria.

Please can the formula identify these duplicates by entering the word 'duplicate' in column L.

Thanks in advance

Sam

Hello Sam

Column D appears to be a description, not a supplier code. That said the following in L2 and copied to end of range:

=IF(COUNTIF($D$2:D2,D2)>1,"Duplicate","Unique")

This will flag duplicates in column D as 'Duplicate', otherwise will return 'Unique'.

depends on what you want to do, delete duplicates leaving 1 unique or delete all duplicates
=IF(COUNTIF($C$2:C2,C2)>1,"Duplicate","Unique") will flag for duplicates leaving first one found not flagged
=IF(COUNTIF(C:C,C2)>1,"Duplicate","Unique") will show all duplicates