software

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

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,quot;quot;)

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 MVPquot;adrianh33quot; gt; wrote in message
...
gt;I am new to using Excel, and need some help.
gt;
gt; I have 2 large columns of data many thousnads of text records, what I would
gt; like to be able to is compare Column A to B and add missing information from
gt; column A to column C. I need to be able to see what is misisng to that I
gt; compile a report using the missing information.
gt;
gt; Is there a way of doing this in Excel