Tag: Query Function

How to Group a Column Based on First Few Characters in Google Sheets

How to Group a Column Based on First Few Characters in Google Sheets

Grouping a column is very easy than you think in Google Sheets. All you need to know is the basic use of Query Function. But some times, you may want to group a data...
Import a Range With Less Than or Greater Than in Google Sheets

Import a Range With Less Than or Greater Than in Google Sheets Query

In Google Sheets the IMPORTRANGE formula can connect two sheets and import data between them. Query is another awesome function in Google Sheets. By using Query with IMPORTRANGE you can apply conditional import range....
How to Use Month Function in Google Sheets Query

How to Use Month Function in Google Sheets Query

You can use MONTH function in Google Sheets Query to return month number from Date. Compare to the Month Function which is part of Date Functions, the Month Scalar Function behaves differently in Query....
How Many Times Each Value Repeat in a Column

Find How Many Times Each Value Repeat in a Column in Google Sheets

I am taking you to another handy Query function tutorial. This time we can find how many times each value repeat in a column in Google Sheets using Query formula. In a large set of...
Age Analysis Using QUERY Function

Age Analysis Using QUERY Function in Google Sheets [Step by Step Guide]

It's quite simple to create an Age Analysis Using Query function in Google Sheets. As I told you many times, in order to enjoy the full benefit of Google Sheets, you should learn the QUERY function...
Limit Number of Rows in Google Sheets Query

Three Different Ways to Limit Number of Rows in Google Sheets Query

If you ask me how to limit number of Rows in Google Sheets Query, I can give you different suggestions. What are they? In Google Sheets you can follow three different ways to limit the...
Bulk Change Case in Google Sheets

How to Apply Bulk Change Case in Google Sheets Using Query Function

With bulk change Case in Google Sheets, what I meant to say is; change the case of complete texts in a table, data range or multiple columns at a time. For this we are...
Google Sheets Query Hidden Row Handling

Google Sheets Query Hidden Row Handling with Virtual Helper Column

I am sure that our topic discussing about Google Sheets Query hidden row handling is quite new to you. Yup! Using Google Sheets Query function, you can select only visible rows in Google Sheets....