Hi all,

Is there a way to check a range for particular values that are
missing?
Suppose I have a list of possible values: A,1,F,G,K,T,3,W,X
And I have the following values in column C:

A
K
1
A
T
X
X
G

Ideally, I'd need a function that would return the following string:

"Missing items: F, 3, W"

The actual list has 20 possible values. My guess is that one should
work with arrays, but my experience with those is very limited. Could
this be solved with some VBA maybe?

thanks for your help,
Jerry