MATCH function?
hi dave and reitanos, this addresses the Yes and some percent issue but
ignores the other text entries which could be in the column. say my column
has these entries: N, P, Y 10%, and Y*. my single cell, which changes, might
be N, then Y, then O, then Y 50%, then P. and my formula should return: true
or 1, 1, 0, 1,1.
would like a formula which can test for all entries (as many as twenty) in
the column as value in single cell changes. hope that's more clear.
|