You can use the Regexmatch in Filter Criteria in Google Sheets to apply more specific filter conditions. But you should take care when you use it in number as well as date columns as it’s a Text function.

If you use the Regexmatch to Filter a number column, format the column to text. You can use the Format menu for formatting number to text (Format > Number > Plain text).

Regarding the date criterion in Regex (Regex in a date column), I have another tutorial. You can find the link under the ‘Related Topics’ at the bottom.

We can learn how to use the Filter Function in combination with Regexmatch with the help of examples. I’ve seven example formulas for you that will take you through different Regex and Filter combinations.

Two must-read articles before further proceeding.

1. How to Use REGEXMATCH Function in Google Sheets.
2. How to Use the Filter Function in Google Sheets [Basic and Advanced Use].

Having said that, let’s move to our core part of this Google Sheets tutorial.

How to Use the Regexmatch in Combination with the Filter Function in Google Sheets

Sample Data to Use for Regex_Filter Combo.

Let’s learn how to use Regexmatch in Filter Criteria in Google Sheets by applying the filter to the above data, i.e. in column A.

Here are those 7 cool Regex Filter combo examples.

As you can see, our data comprise a list of different Virgin Oils and their prices. The first column contains the Virgin Oil Name. Let’s see how to apply different conditions in this column.

Similar: Multiple Conditions in Same Column Filtering in Google Sheets

Examples: Regexmatch in Filter Criteria in Google Sheets

1. Filter Column A contains all the word “Oil”, Case Sensitive.

=filter(A1:D, regexmatch(A1:A, "Oil"))

2. Filter Column A contains all the words “Olive Oil”, Case Sensitive.

=filter(A1:D, regexmatch(A1:A, "Olive Oil"))

3. Filter Column A for either Olive Oil or Coconut Oil, Case Sensitive

It’s multiple conditions in the same column in Filter Function.

=filter(A1:D, regexmatch(A1:A, "Olive Oil|Coconut Oil"))

4. Filter Column A when there is any word within the bracket that only we want to filter.

=filter(A1:D, regexmatch(A1:A, "\(([A-Za-z]+)\)"))

The output of this Filter Regex combo will be #N/A! as there is no such value in column A.

5. Regexmatch with Filter Function, Case Insensitive.

Here it’s a little tricky. You can apply any of the lower / upper/proper cases with Regexmatch regular expression.

Here I’ve used the small case and accordingly used the regular expression in the small case.

=filter(A1:D, regexmatch(lower(A1:A), "oil"))

Similar: How to Apply Bulk Change Case in Google Sheets Using Query Function.

6. How to filter a column based on 3 conditions in that same column using Regexmatch with the Filter function.

=filter(A1:D,regexmatch(A1:A, "Extra Virgin Olive Oil|Pure Virgin Canola Oil|Pure Rice Bran Oil"))

7. Filter Column A for Exact Match

Here no need to use Regex for the exact match. You can directly use the Filter function.

=filter(A1:D, A1:A="Oil")

That’s all for now. Use the above formulas on your own data to learn the use of it. Hope you have enjoyed the stay here.

Related Topics

1. How to Use Regexextract Function in Google Sheets and RE2 Regular Expressions.
2. Google Sheets Regexreplace Function How to and Examples.
3. Regexmatch Dates in Google Sheets – Single/Multiple Match.
4. REGEXMATCH in SUMIFS and Multiple Criteria Columns in Google Sheets.
5. Use Query Function as an Alternative to Filter Function in Google Sheets.
6. How to Use Date Criteria in Filter Function in Google Sheets.