Help with clearing cells with duplicate data without deleting the entire row

DMacSTB,

You have already posted this question as a part of this thread. Hence this thread is being flagged as duplicate and thus closed.