comparing column values

[Guest]

I have two columns with product numbers in them. The first column has
product numbers from the begining of the month. The second column has
product numbers from the end of the month.

I would like to compare them against eachother and find all the new product
numbers. So the new product numbers in the second column.

I was thinking there might be a function to do this but can't figure this
out.

Thanks,
Tricia Gall

 

[Guest]

Check help for the match function.

 

[Guest]

One way ..

Assuming product numbers in cols A & B, from row1 down, where
Col A = existing product numbers
Col B = new & existing product numbers (randomly mixed together)

Put in C1:
=IF(ISERROR(SMALL(D,ROW(A1))),"",INDEX(B:B,MATCH(SMALL(D,ROW(A1)),D,0)))

Put in D1:
=IF(B1="","",IF(ISNUMBER(MATCH(B1,A:A,0)),"",ROW()))

Select C11, fill down to last row of data in col B

Col C will auto-extract the new product numbers in col B,
with all results neatly bunched at the top

 

[Guest]

Max,
Thanks!!!!!! It works!!!!!!

I fully don't understand the formula, but I will sit down and examine it and
break it down till I fully do!!!!!

Have a great Holiday Weekend!

 

[Guest]

You're welcome, Tricia !
Thanks for feedback ..