+ Reply to Thread
Results 1 to 6 of 6

Filter for rows containing 1 of multiple OR criteria

  1. #1
    Registered User
    Join Date
    06-24-2021
    Location
    USA
    MS-Off Ver
    Microsoft 365
    Posts
    10

    Filter for rows containing 1 of multiple OR criteria

    Hello everyone,

    This is probably a SUPER simple question but I've been searching all day and cant find anything that works

    I have a table of data and I want to basically create a new table of only rows containing certain values in column B.

    In my example, I want my new table to only consist of rows from the original table that contain the words "cookies" or "cupcakes". Even better if the new table can be on a separate sheet.

    I hope that this makes sense. Thank you for your help!
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    10,130

    Re: Filter for rows containing 1 of multiple OR criteria

    If you put Cookies in G2 & cupcakes in G3 then you can use
    Formula: copy to clipboard
    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    06-24-2021
    Location
    USA
    MS-Off Ver
    Microsoft 365
    Posts
    10

    Re: Filter for rows containing 1 of multiple OR criteria

    Awesome, thank you! Is there a way to do it so that I don't have to have the filter values listed in another table? I'm hoping to make it as easy as possible for my coworkers to copy and paste the formula in their own spreadsheets.

  4. #4
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    10,130

    Re: Filter for rows containing 1 of multiple OR criteria

    Yup, you can use
    Formula: copy to clipboard
    Please Login or Register  to view this content.

  5. #5
    Registered User
    Join Date
    06-24-2021
    Location
    USA
    MS-Off Ver
    Microsoft 365
    Posts
    10

    Re: Filter for rows containing 1 of multiple OR criteria

    Amazing! Thank you!

  6. #6
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    10,130

    Re: Filter for rows containing 1 of multiple OR criteria

    You're welcome & thanks for the feedback.

+ 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 rows which have multiple criteria
    By edwardrconnor in forum Excel General
    Replies: 1
    Last Post: 06-29-2020, 06:37 PM
  2. Filter table by multiple criteria and delete all irrelevant rows
    By ITY in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-22-2020, 06:28 AM
  3. Select and Delete rows without using filter using multiple criteria
    By sunil10007 in forum Excel - New Users/Basics
    Replies: 8
    Last Post: 11-02-2019, 06:21 AM
  4. Using VBA to filter multiple criteria and then count number of rows with data
    By ajohns52 in forum Excel Programming / VBA / Macros
    Replies: 37
    Last Post: 10-16-2018, 07:47 AM
  5. Replies: 3
    Last Post: 01-18-2018, 12:20 PM
  6. Replies: 0
    Last Post: 08-04-2017, 02:39 AM
  7. [SOLVED] Macro to hide rows (Auto filter) based on multiple criteria
    By pauldaddyadams in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-03-2014, 07:36 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