QUERY Function

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

Google Sheets: Create a Pivot Table with Data from Multiple Sheets

A pivot table is a powerful data summarization tool for any spreadsheet. Since it’s a spreadsheet, it is not uncommon to have data coming from ...

How to Count Unique in Google Sheets (3 Easy Ways)

Today, we will look at a few ways we can count unique entries in Google Sheets. While the idea is simple, it also means that there can be multiple ...

How to Format Date in Google Sheets (3 Easy Ways)

Working with dates is one of the more common tasks available for any spreadsheet user. However, many users of varying expertise still have certain ...

Applying SUMIF from Another Sheet in Google Sheets

SUMIF is one of the fundamental functions of Google Sheets which also means that its application might vary. As such, today we will look at how we ...

How to Sum Multiple Rows in Google Sheets (3 Ways)

Today we will look at how to sum multiple rows in Google Sheets. While one method is expectedly common, the others may prove to help in some dynamic ...

How to Sort by Multiple Columns in Google Sheets (3 Ways)

Today, we will look at how to sort by multiple columns in Google Sheets. While most users will think about the Sort Range option, which we will be ...

How to Query Cell Reference in Google Sheets

Today, we will look at how we can apply a query cell reference in Google Sheets. To give a better understanding, we will use multiple scenarios and ...

COUNTIF Multiple Criteria in Google Sheets (3 Ways)

A veteran in Excel will tell you how powerful the COUNTIF function and all its iterations are. The same importance is carried over to Google Sheets. ...

Count Duplicates In Google Sheets (3 Ways)

When working with spreadsheets there will come a time when you will need to count duplicates in your data, whether it be for extraction or removal. ...

OfficeWheel
Logo