REGEXMATCH Function

### How to Make REGEXMATCH Case Insensitive in Google Sheets

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 Execute Case Sensitive COUNTIF in Google Sheets

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 Return Exact Match in Google Sheets (7 Suitable Ways)

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 ...

### Use REGEXMATCH Function for Multiple Criteria in Google Sheets

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

### How to Use VLOOKUP Function with Wildcard in Google Sheets

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 ...

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

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 ...

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

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: The FILTER Function (A Comprehensive Guide)

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

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

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 for Multiple Conditions in Google Sheets (2 Easy Ways)

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, ...

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

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 ...

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

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 ...

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

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

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

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 if it Contains Value (A Comprehensive Guide)

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 ...