This is kind of hard to explain. Bear with me please.
I have a list of part numbers that we sell. I have imported a list of part numbers that people want to buy. I need to do the following:
1. Compare the two lists and find matches so we can sell these items
2. Sum the number of matches at the top of a third column
3. Create a resulting list of the part numbers under that sum total
The way I have done it was relatively simple. I think there has to be a way to get what I want that I just haven't found.
I have done #1 in column C =COUNTIF($A$1:$A$36019,B2)
And #2 is in column D =IF(C2>0,B2,"")
but what I now have is:
A2:A36018 is our part numbers
B2:BXXX is their part numbers (pulled from a database that changes daily)
C2:CXXX has 0s for non-matches and 1's for matches.
D2:DXXX has a list of part numbers that matched, but as you can imagine, they are maybe 5-10 cells out of 1000, so they're hard to find.
Ideally, I'd like to have A hidden, B hidden and just have one column that says the total number and the part numbers in a list. Any ideas?
Thanks in advance for any help!
I have a list of part numbers that we sell. I have imported a list of part numbers that people want to buy. I need to do the following:
1. Compare the two lists and find matches so we can sell these items
2. Sum the number of matches at the top of a third column
3. Create a resulting list of the part numbers under that sum total
The way I have done it was relatively simple. I think there has to be a way to get what I want that I just haven't found.
I have done #1 in column C =COUNTIF($A$1:$A$36019,B2)
And #2 is in column D =IF(C2>0,B2,"")
but what I now have is:
A2:A36018 is our part numbers
B2:BXXX is their part numbers (pulled from a database that changes daily)
C2:CXXX has 0s for non-matches and 1's for matches.
D2:DXXX has a list of part numbers that matched, but as you can imagine, they are maybe 5-10 cells out of 1000, so they're hard to find.
Ideally, I'd like to have A hidden, B hidden and just have one column that says the total number and the part numbers in a list. Any ideas?
Thanks in advance for any help!