hi i'm trying to use the following excel function:
=SUMPRODUCT(--ISNUMBER(FIND({"toilet","ablution"}),$A$1:$A$6)))
to count the number of time one of the words either toilet or ablution appears in the column selected. however, if both toilet and abultion appears it counts twice and i only want it to count once?
any ideas?
Bookmarks