Column H is a list of six-digit MPNs to be blocked, and Column G shows the component that the MPN relates to. So, within the list of components (columns A:E), I need to count the number of MPNs each Component has...but not including the ones to be blocked (column H). So, if there are 4 different MPN numbers; I want to show that in column J. Then, in column K, I want to show how many of those MPNs have the location of "MTY."
So, I'm just trying to find a formula for columns J and K....
I provided an example in the picture below:
H2 is the first MPN in the list. So, G2 must match B:B (I highlighted the matching component in red). So, I want to count the related MPNs in column C...but excluding the ones where C matches H (highlighted in yellow). You can see I counted the different MPNs from 1-to-4 in blue (I skipped the one in yelow) and I listed that final count in column J. Likewise, I counted column E, where the location was "MTY" and listed the final count in Column K.
[Blocked Image: http://i26.photobucket.com/albums/c117/shocktrooper327/Excel%20Example_zpso4wlcouf.png]