I wanted to use a custom autofilter, but to match any ONE of multiple words. Does not need to be all, just one of them. Can I just separate them by comma's?
I tried it, didn't seem to work, so I'm asking incase it's something else I do to separate the words, such as quotation marks, or asterisks? Not sure. I thought about advanced filter, but I need the criteria to be any one of them, not ALL.
Thanks
screenshot.png
Last edited by hostexaminer; 04-18-2017 at 12:09 AM.
An option here is to add a column, say column N, with a if statement so all your criteria equal 1 for example. Then just filter the 1s.
=IF(OR(M2="vertical", M2="horizontal", M2="new", M2="single"),1,"")
Excel's Advanced Filter can filter for as many values as you want
If the data you want to filter requires complex criteria (such as Type = "Something1" OR Salesperson = "Eddie"), you can use the Advanced Filter dialog box.
See here for details: Advanced Filter
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks