blanchard306
12-08-2016, 03:44 PM
Ok, I have an issue and just can't think of the best way to figure it out.
I have a list with about 40K line items and I need to find what is missing for each Number group. In the attached sample of my data you can see that the first number combo on the Master tab is missing one from the Key tab. I need to know for each number combo which if any are missing from the key tab.
So logic is-
If Type, Prod & G/NG on Master Match on key there should be all the codes from the KEY Tab on the Master Tab. So below is a quick look at the data from the attached file. As you can see one is missing from number group 440. I need a fast way to run through all 40K line items on the Master tab and have it tell me what is missing from each "number" group. On the attached file you will see number group 41MM isn't missing any. Thanks for any help.17791
Master Tab
Key Tab
Type
Number
Code
Prod
G/NG
Type
Prod
Code
Date
G/NG
AF
440
A66AN
S7
G
AF
S7
A66AN
6/21/2010
G
AF
440
A66EN
S7
G
AF
S7
A66EN
2/1/2011
G
AF
440
S70AAN
S7
G
AF
S7
S70AAN
1/1/2011
G
AF
440
S70ACN
S7
G
AF
S7
S70ACN
2/13/2012
G
AF
440
S70AEL
S7
G
AF
S7
S70AEL
2/25/2013
G
AF
440
S70AEN
S7
G
AF
S7
S70AEN
2/25/2013
G
AF
440
S70AFL
S7
G
AF
S7
S70AFL
2/25/2013
G
AF
S7
S70AGN
9/23/2013
G
I have a list with about 40K line items and I need to find what is missing for each Number group. In the attached sample of my data you can see that the first number combo on the Master tab is missing one from the Key tab. I need to know for each number combo which if any are missing from the key tab.
So logic is-
If Type, Prod & G/NG on Master Match on key there should be all the codes from the KEY Tab on the Master Tab. So below is a quick look at the data from the attached file. As you can see one is missing from number group 440. I need a fast way to run through all 40K line items on the Master tab and have it tell me what is missing from each "number" group. On the attached file you will see number group 41MM isn't missing any. Thanks for any help.17791
Master Tab
Key Tab
Type
Number
Code
Prod
G/NG
Type
Prod
Code
Date
G/NG
AF
440
A66AN
S7
G
AF
S7
A66AN
6/21/2010
G
AF
440
A66EN
S7
G
AF
S7
A66EN
2/1/2011
G
AF
440
S70AAN
S7
G
AF
S7
S70AAN
1/1/2011
G
AF
440
S70ACN
S7
G
AF
S7
S70ACN
2/13/2012
G
AF
440
S70AEL
S7
G
AF
S7
S70AEL
2/25/2013
G
AF
440
S70AEN
S7
G
AF
S7
S70AEN
2/25/2013
G
AF
440
S70AFL
S7
G
AF
S7
S70AFL
2/25/2013
G
AF
S7
S70AGN
9/23/2013
G