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.