Need help in comparing data in 2 sheets

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

In Sheet1 B1 and copy down,

=if(isnumber(match(A1, Sheet2!$B$1:$B$13000, 0)), "Both", "Unique")

And then a symmetric formula on Sheet2.

Thanks a lot for your reply! You made my work easier.