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.
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.