Hi, I have been trying to find a way around this for days and can't find a clean simple way of doing this although I'm sure there must be an easy way I have missed.
Essentially, is there a way for a formula to look up a 'value' e.g. "X", in a cell without picking up the content of the formula which may also contain "X"...?
Example
In row A10 I want to flag if a range of cells above it (A1:A9) contain "X" or if they are all blank, i.e. "".
However, because the cells A1:A9 have formulae that determines whether they are X or blank, e.g.=IF(AND(CB$7>=$BL12,CB$7<=$BM12),"X",""),
each time I try a formula such as IFBLANK, or (IF(ISERROR(MATCH("X",A1:A9,1)),"no","yes") these seem to pick up the X in the formulae itself.
Ideally, a IFBLANK formula would be good, but since the cells have formula in them they all show as non-blank, even though the value of the cell may be " ". Or is there a way around this.
Any help with this would be massively appreciated.
Thanks.
Bookmarks