Rag,

I now saw via the link you gave me (http://tinyurl.com/6r97z) your answer in
the Text formula thread:
From: "RagDyeR"
Date: Tue, 15 Feb 2005 03:45:14 -0800
Local: Tues, Feb 15 2005 3:45 am
Subject: Text fomula

Strange enough it does not appear in the thread if I open it in the
excel.misc NG.
I tried you solution and saw that AND(COUNTIF(({list})) does the trick.

Thank you very much.

Jack.

"RagDyeR" schreef in bericht
...
You asked this question 4 days ago, and received some suggestions.
Did you try any of them?

http://tinyurl.com/6r97z
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"Jack Sons" wrote in message
...
I want to check if "apple", "pear", "cherry"; "coconut" and
"apricot" each occur at least once in a given range.

=COUNT(MATCH({"apple", "pear", "cherry"; "coconut","apricot"},D5:D16,0))=5
works but
=COUNT(MATCH({"apple", "pear", "cherry"; "coconut","apricot"},D5:E16,0))=5
does not work.

I heard that match() works only with a single column or row, so the second
formula does not work. How to overcome this? Perhaps with an arrayed
function?

I do not want to work with consecutive countif's, because if my list
{....}has 25 items it is very laborious and cumbersom to write 25
countif's.

Jack Sons
The Netherlands