1

I would like to filter columns in Excel with use of Text Filters based on multiple criteria in text search. Is it possible?

Picture one example of data.]

Example two]

how I would like to filter it based on words "medium" and "big" but not by selecting checkboxes one by one but rather by listing them by keywords.

Improve this question
3
  • You list keywords in a range using the Advanced Filter
    – Ron Rosenfeld
    Aug 4, 2022 at 1:08
  • Something like this but with more criteria.
    – SpitFire
    Aug 4, 2022 at 7:01
  • Be specific. Exactly what are you trying to do that cannot be handled by the Advanced Filter?
    – Ron Rosenfeld
    Aug 4, 2022 at 11:33

2 Answers 2

Reset to default
0

You might consider using wildcards in advanced filtering to filter data. Details can be found in this article: https://trumpexcel.com/excel-advanced-filter/

Improve this answer
0

Expand Text Filters and select Custom Filter

Set the options as shown on the image below. Click OK.

Improve this answer
1
  • It's really close to what I need with exception that I need more than two options. Sorry for not being clear enough.
    – SpitFire
    Aug 4, 2022 at 6:59

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .