column compare

  • Thread starter Thread starter Deborah Mowry
  • Start date Start date
D

Deborah Mowry

I have a column with Items sold (listed in alpha order by the item number).
Another month a worksheet again like the first listing Items sold (it goes
on to say bought by whom etc).
They want me to compare the two worksheets - What was sold in both months
and another answer as to what was not sold.
How do I do this?
Deborah
 
Deborah,

I would first create a list of the products sold in either month using

Data|Filter|Advanced and selecting the product id's for the first month as
the range and selecting the "Copy to new Location" and "Unique Items"
options.

Then Repeating that process for the second months sales, placing the
filtered list right below the list from the first month.

Finally, use Data|Filter|Advanced one more time on this new list and you
will have a list of all products sold in both months.

Using that list (I assume it starts in A1) you can then use this formula

IF(ISERROR(MATCH(A1,"Range of Month 1 Product ids",0)),"","June")&"
"&IF(ISERROR(MATCH(A1,"Range of Month 1 Product ids",0)),"","July")

and you will get a list that includes the months each product was sold that
looks like

June
June July
July
.....

Sort the list as needed

HTH

PC
 
Back
Top