Well its no wonder I couldn't understand it. When you said the reds were counts of the missing numbers to the right, I thought you meant 7 had been missing once, 11 had been missing twice, 14 had been missing 3 times etc.(column C). So the reds are just counts of how many numbers are in the column ?

Therefore the red numbers are irrelevant to the problem you are trying to solve then.

To keep track of the missing or non missing of numbers I have done a table below yours.

I am assuming that the highest number is 36, since you dont mention it. I am assuming that time runs left to right, each pair of columns to the right being the next draw, since you dont mention it.

In order to align the checking with the missing numbers which happen every alternate column, my table is in black in columns where your red numbers are. It shows an "M" where a number is missing above, displaying it opposite the missing number in column A. An empty (non black) cell means the ball is NOT missing, it must have reappeared.

I hope this is what you meant.

It would have been tidier if the draws were not in alternate columns, and it means copying the formulas across to the right to make room for more draws must be done bearing this in mind, copying pairs of columns across.

Thats all I can do for now as your layout stands, it could probably be tidied up with a macro, but I dont have time for that right now.

https://www.mediafire.com/file/453gq8niuu4urq4/Missing+Numbers.xls/file