# Match key list and find missing

#### seattlerose

##### New Member
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 below sample of my data you can see that the first number group on the Master tab is missing one from the Key tab based on Type, Prod & G/NG Combo. I need to know for each number group which if any are missing from the key tab for that Type, Prod & G/NG combo.

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. 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". Thanks for any help.

 Master Tab Key Tab Type Number Group 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

<tbody>
</tbody>

### Excel Facts

Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.

Replies
4
Views
186
Replies
5
Views
365
Replies
9
Views
268
Replies
28
Views
331
Replies
0
Views
173

1,195,991
Messages
6,012,731
Members
441,724
Latest member
Aalbid

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

### Which adblocker are you using?

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

### Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back