Text filter - multiple word search

[jlugo]

Hello all~

For some reason, I can't seem to get this formula right.

I have a column that contains both individual names and corporations. I want to do a text filter (with functions) to only display cell values with company names that contain:

Partner
INC
INC.
CO
University
Associates


=count(SEARCH({"Partner"," INC "," INC."& CO","University","Associates"},A1))>0

Formula above doesn't consistently detect all the cells. An example would be, it captures the word "Cincinnati" as TRUE but Saint John Associates Inc CO as FALSE (when I want it to be true).

How can I build this formula to be equally as good as doing an advance text filter that searches words that contains these key business terms? It should return values that perform AND or OR logic in case more than one word shows up.

 

[jlugo]

Could someone provide two formulas for the Cincinnati & INC CO examples? I want to know how to find exactly what I want and to include spaces or not to include spaces.

 

[tmmellor1981]

This post may help If a cell contains a certain text then put a specified text in another cell?

You need to be careful as using that formula if the company was called Incinerator PLC it with find INC and return it as true

 

[jlugo]

Exactly, I just want to see the difference between two formulas that detect Inc or Inc. vs. Incinerator PLC and/or Inc.