Mar 14 2022 12:08 PM
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
Mar 14 2022 01:36 PM
Solution=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.
Mar 14 2022 01:36 PM
Solution=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.