FILTER Function

How to Create Dependent Drop Down List in Google Sheets

A dependent drop down list is used when one wants to show only relevant information for subsequent dropdowns. It is also known as a dynamic dropdown ...

How to Filter By Rows in Google Sheets (An Easy Guide)

Typically, datasets are presented vertically, with column headers followed by a vertical list of data. But sometimes, you may have data that is given ...

Filter with the AND Condition in Google Sheets (An Easy Guide)

When we filter for multiple conditions in a spreadsheet, we follow one of the two approaches to the relationship of the said conditions: AND or OR. ...

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

How to Filter Based on a Cell Value in Google Sheets (2 Easy ways)

Cell references can be a huge deal when it comes to automating many spreadsheet features, including filtering. Keeping that in mind, in this article ...

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

How to Filter by Condition Using a Custom Formula in Google Sheets (3 Easy Examples)

Using a custom formula is the easiest way to filter by a specific condition in Google Sheets. While the filter feature has improved by leaps and ...

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 for Multiple Criteria with Formula (2 Easy Ways)

Conditional filtering is a staple in many spreadsheet processes. But what if you wanted to filter for multiple conditions? Thankfully, we have a ...

Google Sheets: How to Autofill Based on Another Field (4 Easy Ways)

The term Autofill can take many forms in Google Sheets, of which the most common is the fill-down columns method in a worksheet. On the other hand, ...

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

OfficeWheel
Logo