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

  • Thread starter Thread starter mike
  • Start date Start date
M

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
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Mapping strings to integers 5
Last YTD average in columns with full year of data. 6
matching & combining data from seperate worksheets 2
Match and delete rows on two different sheets from reference numbers 4
Convert Number to Text for Index/Match 1
Excel Comparing two columns 1
Finding matches in two columns 4
matching columns to find differences. 0

Back
Top