Forum Discussion
Filtering multiple columns
Take that sheet with actual names down. It's a violation of the rules here to post real info...privacy rules.
All you need to do to use what I gave you is modify the array that gets filtered, along with the columns specifying the criteria. I can't do it now, but will look later this evening.
Yes that’s very helpful! I really appreciate it. I’m new and my boss gave me this so I am struggling. I would like a good way to design and set it up too. I will include the file in this with the names also if you don’t mind showing me how do that. I really appreciate the help in helping me learn. That’s the full actual sheet
Take that sheet with actual names down. It's a violation of the rules here to post real info...privacy rules.
All you need to do to use what I gave you is modify the array that gets filtered, along with the columns specifying the criteria. I can't do it now, but will look later this evening.
- Okay thanks, sorry will do
- Hello,
I've removed all attachments due to raised security & GDPR concerns. Thank you. I've added a column for the names --- you can just copy and paste them in on the data base. The formula has been adjusted to accommodate the additional data.
- Just found at that at my workplace they are still using excel 2007.. smh so that filter function didn’t work there. Thanks for the help either way, appreciate it.
