Adding a Wildcard in a Dropdown List

I am currently working in a cost center spreadsheet where I have the monthly output for each cost center. I needed to add the functionality to filter by Cost group (G&A, S&M etc). I used some brutally large nested IF statements where I started with IF=“All cost groups” to get the all and then in the value if false section I added the cost group criteria. The issue is I added a cost group, cost functionality and GL code dropdown so the nested if has gotten huge.

Question: Does anyone have any tips on how to use wildcards (or anything similar) so I can have a “All options” in my dropdown so I can avoid the large nested IFs?