agwalsh
asked on
Filter an Excel list by multiple criteria
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
EE_multiple_criteria_selection.xlsx
ASKER
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?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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...)
ASKER
Thanks to both of you for your help.
EE_multiple_criteria_selection.xlsx