Hi,

I have two worksheets which have one column in common. I would like to do the following:

worksheet A contains an id field
worksheet B contains an id field

worksheet B contains more ids than worksheet A

I want to find the intersection of A and B based on the id field

I tried to use the compare and merge workbook option, but this did not work. I think that I might have to write a script to do the above. Any suggestions?

-Eileen