• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 302
  • 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.

1 Solution
Saqib Husain, SyedEngineerCommented:
Try using a helper column. Enter this formula in J2


and copy it down. Now filter on this column.
CptPicardAuthor Commented:
So easy, thanks :)
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.

Join & Write a Comment

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

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