Matching Cell Values?

[camster39]

In Column A I have a master list of all Social Security Numbers.

In column B I have a partial list of Social Security Numbers.

I would like to create a formula in Column C that will return a SSN if it exists in Column A and NOT Column B. If I can't return the actual SSN then just something like "TRUE" if there is a match and "FALSE" if there is not.

Using Excel 2002.

 

[KenWright]

Assuming Col A values in A1:A10000
Assuming Col B values in B1:B1000

In C1

=IF(COUNTIF($B$1:$B$1000,A1)=0,A1,"")

and copy down to C10000

Regards
Ken.............

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission

----------------------------------------------------------------------------