On Friday, June 5, 2015 at 11:10:16 AM UTC+5:30, Nitya Satheesh wrote:
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.

Hi Cameron!
I tried that again and it worked! Thanks a lot !