Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 276
  • Last Modified:

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
0
CptPicard
Asked:
CptPicard
1 Solution
 
Saqib Husain, SyedEngineerCommented:
Try using a helper column. Enter this formula in J2

=COUNTIF(A2:I2,"Yes")

and copy it down. Now filter on this column.
0
 
CptPicardAuthor Commented:
So easy, thanks :)
0

Featured Post

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now