REGEXMATCH Function Archives

How to Make REGEXMATCH Case Insensitive in Google Sheets

August 16, 2023 Formulas

The REGEXMATCH function is a very helpful tool in Google Sheets. However, this function is case-sensitive. So, sometimes it eliminates some matches ...

How to Make REGEXMATCH Case Insensitive in Google Sheets

How to Execute Case Sensitive COUNTIF in Google Sheets

August 16, 2023 Formulas

We often use the COUNTIF function for counting the number of cells based on a specific criterion. However, when we use text criteria in the COUNTIF ...

How to Execute Case Sensitive COUNTIF in Google Sheets

How to Return Exact Match in Google Sheets (7 Suitable Ways)

August 16, 2023 Formulas

While working on a dataset sometime we need the same value from other cells or another sheet, sometimes we need to know the exact place of a ...

How to Return Exact Match in Google Sheets (7 Suitable Ways)

Use REGEXMATCH Function for Multiple Criteria in Google Sheets

August 3, 2023 Formulas

The REGEXMATCH function in Google Sheets determines whether a text string fits a regular expression. If it does, the function returns TRUE; ...

Use REGEXMATCH Function for Multiple Criteria in Google Sheets

How to Use VLOOKUP Function with Wildcard in Google Sheets

August 16, 2023 Formulas

We use the VLOOKUP function to look up any value in a given data range. In addition to that, we can add Wildcard into the VLOOKUP formula to search ...

How to Use VLOOKUP Function with Wildcard in Google Sheets

If Cell Contains Text Then Return Value in Another Cell in Google Sheets

August 10, 2023 Formulas

We often need to insert values into a cell based on other cells in Google Sheets. Also, finding information in a large spreadsheet takes a lot of ...

If Cell Contains Text Then Return Value in Another Cell in Google Sheets

Google Sheets: Sum If there are Multiple Conditions (3 Ways)

October 27, 2022 Basics

In this simple tutorial, we will look at a few scenarios where we sum values in Google Sheets if there are multiple conditions. The Core of the ...

Google Sheets: Sum If there are Multiple Conditions (3 Ways)

Google Sheets: The FILTER Function (A Comprehensive Guide)

April 2, 2023 Basics

Filtering is a primary process that is utilized in most spreadsheets, especially those that contain a large amount of data. While most spreadsheet ...

Google Sheets: The FILTER Function (A Comprehensive Guide)

How to Filter with the OR Condition in Google Sheets (3 Easy Ways)

April 3, 2023 Basics

Filtering with multiple criteria is a common requirement for most spreadsheets. However, doing so gives rise to logical calculations of how these ...

How to Filter with the OR Condition in Google Sheets (3 Easy Ways)

How to Filter for Multiple Conditions in Google Sheets (2 Easy Ways)

April 3, 2023 Basics

Filters are a great tool to help sift through a large set of data and bring out the important ones depending on various conditions. Unlike Excel, ...

How to Filter for Multiple Conditions in Google Sheets (2 Easy Ways)

Filter Entries if it Does Not Contain Value in Google Sheets (2 Easy Ways)

April 4, 2023 Basics

The most common and default approach to filtering is to look for a certain value in a data range. But what if we wanted to filter entries if it does ...

Filter Entries if it Does Not Contain Value in Google Sheets (2 Easy Ways)

Applying Filter with REGEXMATCH Function in Google Sheets (Easy Examples)

April 4, 2023 Basics

The REGEXMATCH function of Google Sheets can help us easily filter for text conditions. Not only that but also thanks to the use of regular ...

Applying Filter with REGEXMATCH Function in Google Sheets (Easy Examples)

Filter Values that Contains Multiple Text Criteria in Google Sheets (2 Easy Ways)

April 4, 2023 Basics

Filtering in Google Sheets is a core process required by most analysts. While there are a plethora of great filter conditions already available in ...

Filter Values that Contains Multiple Text Criteria in Google Sheets (2 Easy Ways)

Google Sheets: Filter Data that Contains Text (3 Easy Ways)

August 7, 2022 Basics

Filtering in a spreadsheet is a common task. But it is good to understand that there are a lot of ways and scenarios where filters can be applied. ...

Google Sheets: Filter Data that Contains Text (3 Easy Ways)

Google Sheets: Filter Data if it Contains Value (A Comprehensive Guide)

July 28, 2022 Basics

Google Sheets has improved in functionality by quite a bit over the years. We now have not only one but two different ways we can filter data if it ...