Tom,

Suppose in A1:F6 there can be all kinds of things (text, numbers, blanks,
formulae), but I want to check if "apple", "pear", "cherry"; "coconut" and
"apricot" each occur at least once. If so a formula in H1 should return
TRUE, if not FALSE.
I tried
=COUNT(MATCH({"apple", "pear", "cherry"; "coconut","apricot"},A1:F6,0))=5
but it won't work, also when array entered.
Your help will be appreciated.

Jack Sons
The Netherlands



"Tom Ogilvy" schreef in bericht
...
Left of a double quote:
=if(counif(B1,"*apple*")0,"apple","")

--
Regards,
Tom Ogilvy