Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Reading " in a range of cells" as " in at least one of the cells of a range". =(SUMPRODUCT(ISNUMBER(FIND(SearchString; Range)) > 0) (Case sensitive)

=ISNUMBER(MATCH(SearchString; Range; 0) if 'Enable regular expressions in formulae' is enabled. (Case insensitive).

(Many variants! See also my answer to your question here.)