Comparing 2 columns of data

[adrianh33]

I am new to using Excel, and need some help.

I have 2 large columns of data many thousnads of text records, what I would
like to be able to is compare Column A to B and add missing information from
column A to column C. I need to be able to see what is misisng to that I
compile a report using the missing information.

Is there a way of doing this in Excel

 

[Bernie Deitrick]

Adrina,

If you want to find the information that is in column A but not in column B, in cell C2, use the
formula

=IF(ISERROR(MATCH(A2,B:B,FALSE)),A2,"")

and copy down to match your data in column A. Then convert column C to values, and sort column C to
get rid of the blanks.

HTH,
Bernie
MS Excel MVP