I am hoping someone can help construct some kind of Lookup+Find/Match formula
to check a column of numbers using a constant array provided e.g.
{1,2,3,4,5,6,7,8} and return the numbers in the column that are missing (if
any). The will be duplicate numbers and blanks, but I want to find out if any
of the numbers in the 1-8 array do not appear at all in the column. Numbers
may vary by column but will be no greater than 8, i.e. col.B: 1-5, col.C:
1-7. For the example below the results should be: Col.A is missing numbers 4
& 7; Col.B is missing number 3; Col.C is missing number 1. Unfortunately I
have no idea how to make this happen. I would greatly appreciate any
responses to help. Thank you!
A B C
2 1 3
2 4
8 7
2 4
3 1 2
1 5 5
6 7
5 6