1. Type the following formula in cell C3:
3. Select cells C3:C34
4. Not sure this works in 2007, but the idea is to then "Edit", select "Fill" on the Edit menu, and then click “Down”.
This will compare Column A against Column B
and if the contents of cell A equals the contents of any cell B
the contents of cell A are inserted in column C.
The columns do not have to be sorted, although it might be easier.
I Started at Row 3, change the formula if needed.
I used only 34 rows to check, again change if needed.