is there way catch cells containing #ref! in functions (not in result), preferably without using vba?
example: catch cells containing e.g. this:
=+substitute("#ref!","#ref!","text")
1) since displayed result of cell "text", not error, =+iserror() won't work.
2) have tried =+sumproduct(isnumber(search("*ref*",a:a))*1) doesn't work either.
3) thing able achieve, identify first cell in column containing "#" use of =+match("#",a:a,-1) that's half of answer since can't/ know how (?) use on several columns.
4) last not least, i'm on excel 2010, no =isformula() available.
any ideas/ appreciated! thanks!
how find & replace , substituting "=getdata" "^^getdata" (replacing = character(s) don't exist in formulae)? can use search on , once you're done replace "^^" "=".
Comments
Post a Comment