How to use autofilter with an array

[Angelfish13]

Hi,

I am trying to filter a list based on certain names that the list can include. My code isn't working and I can't figure out why. The tricky thing is I can't just list all of the names I want to include because there can be several different ones that are spelled slightly different but all mean the same thing, so I need to say "can contain" specific words. I have no problem doing this with 2 names, but when I try to include several (like 8 or 9) excel flips out. The code is below. Is there something wrong with it or is there a way around it? Thank you for your help!

Please Login or Register  to view this content.

[AB33]

My guess is the array might work with exact match only, no like *.

[tigeravatar]

Angelfish13,

Remove all the equal signs, they are unnecessary and confusing the compiler. [EDIT] (This next part is wrong, I apologize) [/EDIT]: The wildcards are fine, you can keep those.

So wildcards will only work in arrays of 2 or fewer elements, sorry for the confusion. Could probably get the data you want a different way though

[tigeravatar]

Maybe give something like this a try

Please Login or Register  to view this content.

[Angelfish13]

Hi everyone,

Thank you so much for the replies. Unfortunately, Tigeravatar, the code did not work I am not sure why. I appreciate the help any way!

[AB33]

"I have no problem doing this with 2 names".
This is also the case with xlor and AND . xlAnd operators. They can handle two options only.
The other option would be to create layers of filter for pairs, but the code may look cumbersome.

[Angelfish13]

I know I have realized this now I found a workaround solution to my problem (just typed in every possible name I could think of that could somehow come up in an array). its just super messy and will probably take forever to run. Better than nothing though!