+ Reply to Thread
Results 1 to 3 of 3

Filter function with wildcard and multiple search values

  1. #1
    Registered User
    Join Date
    09-27-2019
    Location
    Dublin
    MS-Off Ver
    Office 365 Pro Plus
    Posts
    19

    Filter function with wildcard and multiple search values

    Hi,



    I am looking at putting together a filter formula that I am not having any luck with.
    I am fine with a filter formula, and I am fine putting a wildcard on it's search value,
    however I fall short when i try to incorporate multiple search values.
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    11-02-2016
    Location
    NY
    MS-Off Ver
    2010
    Posts
    459

    Re: Filter function with wildcard and multiple search values

    Check out ADVANCED FILTERs. You need to set up a CRITERIA range (where you filter the data; you may need to add wildcard '*' before and after your search value), set up original data LIST, and then the COPY TO RANGE (I usually set below the Criteria Range.
    Attached Files Attached Files

  3. #3
    Forum Expert WideBoyDixon's Avatar
    Join Date
    10-03-2016
    Location
    Sheffield, UK
    MS-Off Ver
    365
    Posts
    2,182

    Re: Filter function with wildcard and multiple search values

    Hmmm. I get a #CALC error when trying to filter the whole sheet. Cutting it down to 2000 rows I could use this:

    Please Login or Register  to view this content.
    WBD
    Office 365 on Windows 11, looking for rep!

+ 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. [SOLVED] Using multiple criteria with a wildcard to return multiple values
    By chrisou in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-07-2021, 04:16 AM
  2. Replies: 1
    Last Post: 10-14-2021, 03:25 AM
  3. Maximum by using search with wildcard and using index match function
    By mzbabar in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-16-2020, 09:10 AM
  4. Wildcard search and return multiple rows
    By JahSon in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-30-2018, 03:07 PM
  5. Replies: 4
    Last Post: 09-23-2016, 01:22 PM
  6. Replies: 2
    Last Post: 09-12-2015, 11:02 AM
  7. If function + Find Function to search for multiple values
    By HabsFan89 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-21-2015, 12:11 PM

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