Thread: MATCH function?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
mwam423 mwam423 is offline
external usenet poster
 
Posts: 103
Default 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.