Hi Ladron,

Welcome to the forum.

This can be achieved using lookup function using which the duplicated can be tracked and then can be easily removed. please upload a sample workbook. Thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>