Sheet Comparison
 

I have a 3 sheet file. Sheets 1 and 2 are exactly the same. There is an
SSN and an amount in each sheet. something similar to the following.

Ssn 123
Ssn 222
Ssn 222
Ssn 555
Ssn 333
Ssn 444
Ssn 666


I need sheet 3 to contain the SSNs and the amounts of the values where sheet
1 and sheet 2 are different. So if sheet 1 had an ssn of 123-45-6666 and an
amount of 1.23, and sheet two had the same ssn and an amount of 3.43, i
would need this ssn and amount populated in sheet 3. Any suggestions???

Thanks in advance.

Sheet Comparison
 

Pl don't multipost. I've posted a response to you in .worksheet.functions
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---