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>
Bookmarks