Hi,

I am looking to run a count (or similar) function to find cells that contain two words that are not immediately following.

E.g.
Cell B2: "this cell contains text"
Cell B3: "this cell contains no text"
Cell B4: "this table contains no text"

Count (how many times "no" and "cell" appear in the same cell). =1

Can anybody advise such a function?