I have a list in one column, of form names.
Each form should have a correspond state code in the column next to it.
Every form should be listed 50 times, each with only one state next to it.
Is there a non-VBA formula that checks for that and tells me what is missing, either form or state?
It can be 2 different formulas, one checking for missing forms, and one for missing states