filter columns in excel

Posted on 2011-10-06
Last Modified: 2012-05-12
I have 2 columns in an excel sheet that I want to filter. The cells in each column contains either "YES" or "NO".
I only want to show the rows which have a "YES" in one or both columns. (In other words, hide rows that have "NO" in both columns). I am not sure how to do this by filtering/sorting.
Question by:RTsal
    LVL 50

    Accepted Solution

    You could use a third column


    that will give TRUE in the columns you want. Filter by that third column

    regards, barry
    LVL 8

    Expert Comment

    You want to use autofilter.

    Either select the whole data section, or if it is a table i think you only need to select a cell.
    Then turn on autofilter

    You will get a drop-down filter tool in each column heading that you can use to adjust filtering.

    For complete info, you might try

    Author Closing Comment

    I knew how to do it using an additional column but I wanted to see if there was away to filter it without adding another column

    Featured Post

    6 Surprising Benefits of Threat Intelligence

    All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

    Join & Write a Comment

    Dealing with unintended Excel Active-X resizing quirks (VBA code simulates "self correction") David Miller (dlmille) Intro Not everyone is a fan of Active-X controls in spreadsheets (as opposed to the UserForm approach, the older Form controls …
    Introduction While answering a recent question (http:/Q_27311462.html), I created an alternative function to the Excel Concatenate() function that you might find useful.  I tested several solutions and share the results in this article as well as t…
    This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.
    This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

    728 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    20 Experts available now in Live!

    Get 1:1 Help Now