Filter function with wildcards
Results 1 to 2 of 2

Thread: Filter function with wildcards
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    Aug 2007
    Location
    NJ, USA
    Posts
    71
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Filter function with wildcards

    Hello,

    I'm trying to figure out how to use the new filter function in Office 365 Insiders. =FILTER(tblCourses[Name],tblCourses[Name]=B1) works perfectly fine if the text in B1 explicitly matches the text in the Name column of the tblCourses table.

    What I'm trying to do is incorporate a loose search so that for example, if "Python" was in B1, than courses "Python for Beginners" or "Variables in Python" would be returned.

    I thought maybe =FILTER(tblCourses[Name],tblCourses[Name]="*"&B1&"*") would work but it doesn't. Anyone have any idea how to accomplish this with the filter function?

  2. #2
    Board Regular
    Join Date
    Aug 2007
    Location
    NJ, USA
    Posts
    71
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Filter function with wildcards

    So I was able to figure it out. For anyone who has the same question and is on Office 365 Insiders, the following formula works. It's results return anything with the text in cell B1.

    =FILTER(tblCourses[Name],ISNUMBER(SEARCH(B1,tblCourses[Name])))

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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