google-query-language Examples and Free Source Code

Google Sheet Query Count working, but other functions are not (e.g., sum, avg)...

google-sheets google-sheets-formula google-query-language

Google Sheets Query Function - Where column not equal to a specific range of cells...

google-sheets google-query-language

How to create a formula that will repeat a range by splitting one column and joining with the other ...

google-sheets split google-sheets-formula google-query-language first-normal-form

How to change this formula to be case insensitive...

if-statement google-sheets formula case-insensitive google-query-language

Repeat Rows per number of elements in next column...

loops google-sheets split flatten google-query-language

ABS formula within a QUERY in Google Sheets...

google-sheets absolute google-query-language

How to make a Google query pull only TRUE values from two different columns...

checkbox google-sheets google-sheets-formula google-sheets-query google-query-language

Convert blank values to zero when using the Query function...

arrays if-statement google-sheets google-sheets-formula google-query-language

Google Sheets linking two sheets using a primary key...

arrays google-sheets vlookup flatten google-query-language

How do I get text in a pivot table in excel or google sheets?...

excel google-sheets pivot pivot-table google-query-language

Imported data into Google Sheets, match and change one Column of Data...

google-sheets indexing google-sheets-formula match google-query-language

Array Formula For Maxifs...

sorting google-sheets max array-formulas google-query-language

Excluding Data in Googlesheet...

google-sheets filter match array-formulas google-query-language

How to use Google Query to combine multiple rows into a single row with IF & SUM...

google-sheets google-sheets-formula google-query-language

sum values which satisfy conditions in google sheets...

google-sheets group-by sum match google-query-language

Finding the most appearing value for each column a value...

google-sheets google-query-language

How to Importrange + CountIf on Google Sheets...

google-sheets import count match google-query-language

Google Spreadsheet error Text result of TEXTJOIN is longer than the limit of 50000 characters...

google-sheets join concatenation google-query-language textjoin

Label giving error when using formulas within query statement/parameter in QUERY in Google Sheets...

google-sheets label google-sheets-formula multiple-columns google-query-language

How can I merge duplicate rows in a Spreadsheet while summig the numerical columns?...

arrays google-sheets sum match google-query-language

Importrange with query and reorder some of the columns on import Google Sheets...

google-sheets google-sheets-formula google-query-language

Using QUERY on Google Sheet returning "Formula parse error"...

google-sheets sum google-sheets-formula sumifs google-query-language

Google Sheets using QUERY IMPORTRANGE from another sheet but query where references current sheets...

google-sheets import google-sheets-formula dropdown google-query-language

Selecting few columns in Google Sheet's QUERY function...

google-sheets google-sheets-formula google-query-language

Ignore case sensitive for given word...

google-sheets google-sheets-formula google-query-language

How can you add more sheet tabs to existing IF/SumIF Google Sheet formula?...

if-statement google-sheets lambda sum google-query-language

How to get multiple pages table like next page in one sheet in google sheet...

google-sheets web-scraping lambda import google-query-language

Copy/pasting query in Google Sheets between cells with automatic replacement of values...

sorting google-sheets google-sheets-formula limit google-query-language

Query function to contain date operations [DATE + X number of months]...

date google-sheets sum match google-query-language

How to avoid this empty row using QUERY() in Google Sheets?...

if-statement google-sheets google-sheets-formula unique google-query-language