We help IT Professionals succeed at work.

Filter an Excel list by multiple criteria

112 Views
Last Modified: 2017-04-13
Is there a way to filter the list I have attached by 3 criteria e.g. Organisation name in cell C1 and by Month in cell E1 and by the transaction t ype on cell G1. I get that I can do it with ONE criteria using Advanced filters but can I do it with multiple filters??
EE_multiple_criteria_selection.xlsx
Comment
Watch Question

CERTIFIED EXPERT

Commented:
Helper Column - Check the attached file Column K
EE_multiple_criteria_selection.xlsx

Author

Commented:
hm, that's basically a filter they have to apply, not much different from just your regular filter... Is there any way to do what I want - filter using 3 criteria in 3 separate cells?
CERTIFIED EXPERT
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION
CERTIFIED EXPERT
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION

Author

Commented:
I went back to the person and really the actual user is totally fine with just filtering (believe me, it's many times better than what they have at the moment...)

Author

Commented:
Thanks to both of you for your help.
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.