Link to home
Start Free TrialLog in
Avatar of agwalsh
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
Avatar of abbas abdulla
abbas abdulla
Flag of Bahrain image

Helper Column - Check the attached file Column K
EE_multiple_criteria_selection.xlsx
Avatar of agwalsh
agwalsh

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
Avatar of abbas abdulla
abbas abdulla
Flag of Bahrain image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of agwalsh

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...)
Avatar of agwalsh

ASKER

Thanks to both of you for your help.