Home » Google Sheets: How to Use FILTER with Wildcard

Google Sheets: How to Use FILTER with Wildcard

by Erma Khan

You can use the following formula in Google Sheets to use a wildcard character within a FILTER function:

=FILTER(A2:C11,search("avs",A2:A11))

This particular formula will filter the cells in the range A2:C11 to only contain the rows where the value in A2:A11 contains “avs” somewhere in the cell.

The following example shows how to use this formula in practice.

Example: Use FILTER with Wildcard in Google Sheets

Suppose we have the following dataset in Google Sheets that contains information about various basketball players:

Now suppose that we would like to filter the dataset to only contain rows where the value in the Team column contains “avs” somewhere in the name.

We can type the following formula into cell A13 to apply this filter:

=FILTER(A2:C11,search("avs",A2:A11))

The following screenshot shows how to use this formula in practice:

Google Sheets filter with wildcard

Notice that the only rows displayed in the filtered dataset contain the string “avs” somewhere in the team name.

To search for a different string, simply replace “avs” with another string in the formula.

For example, we can use the following formula to filter for rows where the team name contains “ets” somewhere in the name:

=FILTER(A2:C11,search("ets",A2:A11))

The following screenshot shows how to use this formula in practice:

Now the only rows displayed in the filtered dataset contain the string “ets” somewhere in the team name.

Additional Resources

The following tutorials explain how to perform other common tasks in Google Sheets:

How to Use Wildcard Characters in Google Sheets Query
How to Use COUNTIF with Wildcards in Google Sheets

Related Posts