comparing numbers in two columns matching them and showing the ones that dont match

[mike]

Here is the question. I have two columns and each column has item
number from a catalog, one for OCtober and one for November. What I
need to do is find out which items are new for november, which have
been removed from the november catalog and which are the same using
excel. Please help

 

[Frank Kabel]

Hi
as a starting point:
http://www.cpearson.com/excel/duplicat.htm#InOneNotOther
http://www.cpearson.com/excel/duplicat.htm#ExtractingCommon

 

[Myrna Larson]

Assuming Oct is in column A and Nov in column B, set up columns headed New and
Removed.

In the New column, put this formula:

=IF(COUNTIF($A:$A,B2)=0, B2&" is new","")

In the Removed column, put this formula:

=IF(COUNTIF($B$B,A2)=0,A2&" was removed","")

Copy the formulas down as far as needed.

For items that are the same, both columns will appear to be empty.