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)
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)