+ Reply to Thread
Results 1 to 4 of 4

Filter multiple columns to show rows that satisfy the criteria in either columns

  1. #1
    Registered User
    Join Date
    01-18-2018
    Location
    London
    MS-Off Ver
    2013
    Posts
    3

    Filter multiple columns to show rows that satisfy the criteria in either columns

    Hi I'm trying to solve a problem where I need to be able to filter a table with multiple columns. The usual filter function shows the rows that satisfy the criteria of the filter in that single column and if I were to filter on multiple columns it would only show the rows that satisfied the criteria in both columns. I need to be able to show the rows that satisfy the criteria in either columns not both.

    Example sheet attached. I want to filter to only show the changes that are yes to either the red team or the green team - i.e. hide Change5 but the rest should stay.

    Thanks,

    David
    Attached Files Attached Files

  2. #2
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    Office 365 ProPlus
    Posts
    5,770

    Re: Filter multiple columns to show rows that satisfy the criteria in either columns

    Use advanced filter.

    First, set up criteria field.
    0.JPG

    Then go to Data ribbon tool and click on "Advanced" found in Sort & Filter section.

    Set it like below.
    1.JPG

    Hit ok and it will only show Change1 to 4.

    Read link for more detailed tutorial.
    http://www.contextures.com/xladvfilter01.html
    “Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something.”
    ― Robert A. Heinlein

  3. #3
    Registered User
    Join Date
    01-18-2018
    Location
    London
    MS-Off Ver
    2013
    Posts
    3

    Re: Filter multiple columns to show rows that satisfy the criteria in either columns

    Legend, that worked great. Thanks very much for your help

  4. #4
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    Office 365 ProPlus
    Posts
    5,770

    Re: Filter multiple columns to show rows that satisfy the criteria in either columns

    You are welcome.

    If your query is resolved, please mark the thread as solved by using thread tool found at top right of your initial post.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. filter multiple columns with same criteria
    By BORUCH in forum Excel Programming / VBA / Macros
    Replies: 20
    Last Post: 06-21-2017, 12:58 PM
  2. Loop filter multiple criteria different columns
    By furiousfox in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-09-2017, 11:16 AM
  3. Search Multiple Columns and Rows - Show results in Multiple columns and rows
    By heykeighley in forum Excel Programming / VBA / Macros
    Replies: 20
    Last Post: 08-12-2015, 10:16 AM
  4. VBA to Hide/show columns based on a filter and multiple criterias
    By Daniel B in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-10-2014, 05:07 AM
  5. [SOLVED] Filter to show multiple columns that satistfy single criteria
    By singerj6 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-13-2014, 02:34 PM
  6. Replies: 2
    Last Post: 06-15-2012, 05:34 PM
  7. [SOLVED] How do I filter columns of merged cells to show all related rows?
    By mosaic in forum Excel General
    Replies: 2
    Last Post: 07-05-2006, 05:10 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1