Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Hi

To get the result regardless of options, you can use (not case sensitive):

=SUMPRODUCT(ISNUMBER(SEARCH(E2;B7:R29)))

or (case sensitive)

=SUMPRODUCT(ISNUMBER(FIND(E2;B7:R29)))

Regards