Developer Forum

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

Hi
as a starting point:
http://www.yqcomputer.com/ #InOneNotOther
http://www.yqcomputer.com/ #ExtractingCommon

"mike" < XXXX@XXXXX.COM > schrieb im Newsbeitrag

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.