Excel comparison

Say for example there are two excel sheets sheet1 and sheet2…
sheet1 and sheet2 are to be compared on certain columns such that
the result should be two new sheets result1 and result2
result1 - contains rows present in sheet1 but not in sheet2
result2-contains rows present in sheet2 not in sheet1.

How ever there is a column key in sheet1 which is not compared but the requirement is the result1 in addition to containing the rows present in sheet1 should also contain the key number corresponding to each row present in sheet1.
Please note this sheet column is not suppose to be compared.
Please help on this one

A post was merged into an existing topic: Comparing Two excel files