Functions

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

How to Fill Down an Entire Column in Google Sheets (4 Easy Ways)

Inputting data in a spreadsheet one by one can be long and tedious. Thankfully, applications like Google Sheets provide its users with multiple ways ...

Google Sheets Smart Fill: Recognize and Autocomplete Patterns (A Complete Guide)

If you’ve been following recent updates, you will know about the new AI-powered addition to Google Sheets, the Smart Fill. In this article, we ...

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

How to Filter Custom Formula in Google Sheets (3 Easy Examples)

Sometimes the available filter options of the spreadsheet just do not cut it. While there are many, the user may require a customized approach to ...

How to Autofill Formula in Google Sheets (3 Easy Ways)

The autofill option is a much-desired feature for any user of office applications. Not only is it convenient, but it is also a time-saver to go ...

How to Use a Custom Formula in a Google Sheets Slicer (An Easy Guide)

Since slicers are essentially a type of filter, there can arise situations where the user might need to customize the filter conditions to suit their ...

Find the Top 10 Values in a Google Sheets Pivot Table (2 Easy Examples)

While there are no direct ways, it is still possible to find the top 10 values in a Google Sheets pivot table. In this article, we will explain ...

OfficeWheel
Logo