J
Jack Sons
Hi all,
More than 24 hours ago I posted a question in the thread Text formula, but
it seems not to arrive. Therefore I repeat my question here:
R,
Thank you very much, it indeed works for D516 , also for D5:E16 (what I
was looking for, more that one dimension).
What also works to check if "apple", "pear", "cherry"; "coconut" and
"apricot" each occur at least once in a given range is
=COUNT(MATCH({"apple", "pear", "cherry"; "coconut","apricot"},D516,0))=5
but
=COUNT(MATCH({"apple", "pear", "cherry"; "coconut","apricot"},D5:E16,0))=5
does not work.
I got stuck with this problem, why does it work for a one column range but
not for a two column range? I really want it solved, also because the
list or array way (how should I call it?), with {......} is so elegant and
easier to use.
Can you or anybody out there in this august newsgroup help (and explain)?
Jack.
More than 24 hours ago I posted a question in the thread Text formula, but
it seems not to arrive. Therefore I repeat my question here:
R,
Thank you very much, it indeed works for D516 , also for D5:E16 (what I
was looking for, more that one dimension).
What also works to check if "apple", "pear", "cherry"; "coconut" and
"apricot" each occur at least once in a given range is
=COUNT(MATCH({"apple", "pear", "cherry"; "coconut","apricot"},D516,0))=5
but
=COUNT(MATCH({"apple", "pear", "cherry"; "coconut","apricot"},D5:E16,0))=5
does not work.
I got stuck with this problem, why does it work for a one column range but
not for a two column range? I really want it solved, also because the
list or array way (how should I call it?), with {......} is so elegant and
easier to use.
Can you or anybody out there in this august newsgroup help (and explain)?
Jack.