One basic way to compare your data would be to set up a formula using the IF
Function in conjunction with the COUNTIF Function. Example:
A C D
Col 1 Data Col 2 Data No Match
1 1
2 2
3 3
4 4
7 5 7


The formula: =IF(COUNTIF(Col2Data, A2)=0, A2, " ") is propagated in Column D
using fill handle. Col2Data is the Range Name given to Column C.

"Anna_Stephanie" wrote:

Hello All:

I am using Excel 2007. I have a worksheet with two columns of data. I
need to compare the data between the two columns to find out which
ones are missing. I cannot get this to work right in Excel 2007 using
the PivotTable button. Any help is appreciated. Thanks.