Hi,
I've got two excel sheets with each sheet having a single column of records. There are 15,000 records in the first sheet and nearly 13,000 records in the second sheet. The data is basically account numbers. I want to find out three things. First one is the account numbers which are common among the sheets. Secondly, I want the account numbers which are present in the first sheet but not in the second sheet. Finally, I want the account numbers which are present in the second sheet but not in the first sheet. Please let me know how to achieve this. My version of Excel is 2003.
Thanks in advance!
Regards,
Babu
Bookmarks