Compare data in two columns

E

excellearn2006

I have two columns of similar looking data. Some of the values may match,
while the other may not. Is there a formula for me to find out the data in
one column that do not match with the data in the other
 
E

excellearn2006

Let's say I have 10 records for column A and 20 records for column B. What if
I wanted to list all the records in column B that do not match with column A-
in column C.
 
Top