comparing column values

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

Check help for the match function.

"gall" wrote:

> 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

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:D,ROW(A1))),"",INDEX(B:B,MATCH(SMALL(D:D,ROW(A1)),D:D,0)))

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

Select C1:D1, 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
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"gall" wrote:
> 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

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!

"Max" wrote:

> 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:D,ROW(A1))),"",INDEX(B:B,MATCH(SMALL(D:D,ROW(A1)),D:D,0)))
>
> Put in D1:
> =IF(B1="","",IF(ISNUMBER(MATCH(B1,A:A,0)),"",ROW()))
>
> Select C1:D1, 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
> --
> Max
> Singapore
> http://savefile.com/projects/236895
> xdemechanik
> ---
> "gall" wrote:
> > 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

You're welcome, Tricia !
Thanks for feedback ..
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"gall" wrote:
> 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!