CptPicard
asked on
Advanced Filtering Yes and No
Hi -
I've got an excel spreadsheet that I'd like to filter to show 2 or more Yes's within multiple columns. Any rows which don't have two or more 'Yes's' will be removed to only show those rows that qualify.
I've tried the advanced filtering but can't seem to get that to work. Perhaps it would work better with a script?
Excel example attached.
Thanks.
Example.xlsx
I've got an excel spreadsheet that I'd like to filter to show 2 or more Yes's within multiple columns. Any rows which don't have two or more 'Yes's' will be removed to only show those rows that qualify.
I've tried the advanced filtering but can't seem to get that to work. Perhaps it would work better with a script?
Excel example attached.
Thanks.
Example.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER