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
CptPicardAsked:
Who is Participating?
 
Saqib Husain, SyedConnect With a Mentor EngineerCommented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.