Hi,
Formula : =IF(SUM(COUNTIF(B2,{"*VACCIN*","*IBACK*","*BUSINESS*","*ICAEW*","*RECRUIT*"}))>0,"NT","T")
I have created a formula to detect certain words contain in a sentence. If the sentence contains the word in my list, the result is "NT", otherwise the result is "T".
I would like to seek for help to shorten the formula as the word I am looking for can be a lot (I just put a few examples of word in the above formula). The formula has to provide the flexibility to detect word like "vaccinations".
I have enclose the excel file for your reference.
Thanks.
Bookmarks