Advanced Filter "like" method

[michlimes]

Hello All,

I would like to perform advanced filter with some wildcards - I want to filter out rows for which one of fields is equal "KM" or "KL".

I tried to do something like "K[ML]" - but it doesn't work (I understand that Excel is trying find K[ML] string).

Is there any method to do it with Advanced Filter? (I would like to avoid using the formulas)

 

[Andrew Poulsom]

Can't you just use 2 rows for your criteria?

http://www.contextures.com/xladvfilter01.html#CriteriaRange

 

[michlimes]

Can't you just use 2 rows for your criteria?

http://www.contextures.com/xladvfilter01.html#CriteriaRange

My excel file allows to type filter options - user can "add" additional variant of filter - and it would be best if user can add this criteria in one row.

There is no feature in advanced filter like in i.e. SQL? ("LIKE '[AF]2'")

 

[Andrew Poulsom]

There is no feature in advanced filter like in i.e. SQL? ("LIKE '[AF]2'")

No, you will have to use 2 rows or a formula.