Identify missing values

HI

I have attached a simpler way of doing things using an array formula, so you do not need columns B,C and D. The formula can be copied and pasted but if you make any changes you will need to use ctrl-shift-enter to ensure it functions correctly.

By having the values you are checking kept separately they can be changed without affecting the formula itself.

Regards

Jeff