SOLVED

Filtering a Column containing.....

New Contributor

I have 2 columns, the first is labeled County and the second is labeled Protected Forest. There are 500+ rows... I want to sort for all the forests in x, x, and x county. Example: What forests are in the following counties? I can figure out how to capture 2 through doing the filter and saying "Contains" "Union" OR "contains" "green" however I can't do more than 2 like that.... this HAS to be way easier than I'm making it. I did it all the time in Google Sheets.

 

Ex:

 

County | Forest

 

Union | Black Forest

Washington, Green | Cherokee Forest

Alexander, Union | Knob Forest

Green | Down Forest

Greenville, Pickens | Walhalla Forest

Greenville, Union, Green | Fort Bragg Forest

Anderson, Buncombe, Henderson | Ash Forest

Buncombe | Brown Forest

 

2 Replies
best response confirmed by Hans Vogelaar (MVP)
Solution

@sjland 

=FILTER(B2:B9,ISNUMBER(SEARCH("Union",A2:A9))+ISNUMBER(SEARCH("Pickens",A2:A9))+ISNUMBER(SEARCH("Anderson",A2:A9))+ISNUMBER(SEARCH("Washington",A2:A9)))

Maybe with this formula which seems to work in my sheet. 

Thank you so much, that worked!!