**BruNL_2017**, Good morning.

"

*...Your function works perfectly only if you substitute FIND with SEARCH:...*"

The difference between these functions in Excel is that the FIND is case-sensitive and the SEARCH does not differentiate.

Depending on your data one of them will actually be more suitable for the correct use.

"

*...Besides, I have found an additional function, much simpler than expected:
*

=COUNTIF(A2:A18,"*luke*mark*")..."

Are you sure that this formula is providing the

**correct result**?

If in your data

*will always* appear the word

**luke** before the word

**mark** this formula works.

**But** if any case appears in different order the words the formula will not count.

This is not the case with the formula I suggested earlier.

I hope it helps.

--

Belo Horizonte,

**Brasil**.

Marcílio Lobão