Detect Presence Formula
I need a formula that will detect the presence of a value in an unsorted
named array.
Column A would be the named array.
Column B would be the value I want to test for.
Column C would be the formula.
So, this is sort of what it would look like. "D" is the only value that
would return a True because it is the only value present in the named array.
D I False
B O False
W D True
T A False
J P False
Anyone know how to do this?
|