How to use FILTER function with wildcard?

user_12592734 0
Viewed 1665

I'm trying to use the Google Sheets FILTER function to filter for string that contains the word 'groups'.

The code I'm using is this:

=filter(A2:C2262,B2:B2262="*"&"groups"&"*")

Unfortunately, it doesn't work as the error message I receive is "No matches are found in FILTER evaluation."

I've attached a screenshot to show the table I'm working with.

How do I make this work?

screenshot of what I'm trying to do

google-sheets-formula google-sheets filter
1 Answers

try:

=FILTER(A:A, SEARCH("*group*", A:A))

enter image description here

user_56326290
Related