Filter function with wildcards

[reaktorblue]

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?

 

[reaktorblue]

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])))