# Revision history [back]

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).