Thanks for your reply. But I only want to remove duplicates in column "R" instead of "A"
So how do I select which column.