What about if you want to find a text string that is returned by a formula?
i have a few cells with formulae of this ilk:
if(a1<>a2*1.2,"boo boo here: vat error","")
if(and(b1>0,b2>0,"boo boo here: can't both be true","")
and i want to search the document for "boo boo" and return each one...
so countif works fine, but that just counts them
I wouldn't mind using match (column by column as it can't do multiple ones at once), but it counts cells with "*boo boo*" in the formulae, rather than just those that output the text string in question...
Can you put conditions inside the match function that discludes formulae
for example (though this doesn't work):
=match(and("boo boo*",<>",?boo boo"),a1:a999,0)
then as a secondary issue, once i've got that working, how do you use match or another function to return the second, third or fourth instance of a reoccurring text string..?
I'll be quite impressed with the person who solves this.
Cheers,
thegurumonkey