Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
comparing column values
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
comparing column values
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
comparing column values
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Format as a MACRO | Excel Worksheet Functions | |||
To copy values in a column relevant to text in an adjacent column? | Excel Worksheet Functions | |||
Lookup Table Dilemma | Excel Worksheet Functions | |||
How sum values in column B using values in column A as the conditi | Excel Worksheet Functions | |||
Need help with lookup and comparing values | Excel Worksheet Functions |