On Thursday, June 4, 2015 at 8:53:59 PM UTC+5:30, Cameron Mitchell wrote:
Hi,

try this:

Highlight both columns and use the "Remove Duplicates" button in the "Data" ribbon. Select both columns, and click "ok"

hope that helps,

Cameron

Hi Cameron,

I tried that and got"no duplicates found". I don't know why that happened.