Search code examples
QUERY function to create pivot table with strings...


google-sheetspivot-tablegoogle-query-language

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


google-sheetsgoogle-sheets-formulagoogle-query-languagepandas-explodefirst-normal-form

Read More
How to transpose & split multiple columns and repeat specific cells in a column...


google-sheetsgoogle-query-languagepandas-explode

Read More
How do I do basic date grouping operations in Google Sheets?...


dategoogle-sheetsgoogle-sheets-formulagoogle-query-language

Read More
How to use date with LIKE inside query?...


google-sheetsgoogle-sheets-formulagoogle-formsgoogle-query-language

Read More
Query formula not grouping properly...


google-sheetsgoogle-sheets-formulastring-formattinggoogle-query-language

Read More
Joining more than two WHERE statements in Query Language...


google-sheetsgoogle-query-languageand-operator

Read More
Why does my Google Sheets query simplificaiton result in an error?...


google-sheetsgoogle-sheets-formulagoogle-query-language

Read More
Datetime comparison query...


google-sheetsimportspreadsheetgoogle-query-languagetextjoin

Read More
Fastest way to search for a row in a large Google Sheet using/in Google Apps Script...


performancegoogle-apps-scriptgoogle-sheetsgoogle-visualizationgoogle-query-language

Read More
INNER JOIN in Google Spreadsheets...


arraysgoogle-sheetsgoogle-sheets-formulaflattengoogle-query-language

Read More
Google Sheets Query...


google-sheetsgoogle-query-language

Read More
How to use VLOOKUP() + QUERY() + IMPORTRANGE() with multiple conditions?...


google-sheetsimportgoogle-sheets-formulaformulagoogle-query-language

Read More
Return SUM of all cells that fit TWO CRITERIA related by POSITION...


google-sheetsfilterlambdasumgoogle-query-language

Read More
How to combine data from multiple rows into a single row based on numbers and certain texts in Googl...


google-sheetscountaverageflattengoogle-query-language

Read More
Date base data sheet generation from master sheet...


google-sheetsgoogle-query-language

Read More
COUNTA returning 1 when expect 0, even when IFNA is used...


google-sheetserror-handlingcountgoogle-sheets-formulagoogle-query-language

Read More
Google Sheets Query - Changing Query Data Range Based using a reference cell...


arraysgoogle-sheetsexcel-formulaformulagoogle-query-language

Read More
Prevent SPLIT from converting text to numbers in Google Sheets when used in an ARRAYFORMULA?...


if-statementfilterlambdagoogle-sheets-formulagoogle-query-language

Read More
Is there a way to simplify the multiselect query in the google sheets?...


google-sheetsfilterlambdareducegoogle-query-language

Read More
Arrayfomula with filter on entire column...


google-sheetsfilterlambdagoogle-query-languagetextjoin

Read More
Google Sheets query formula partially working...


if-statementgoogle-sheetsselectformulagoogle-query-language

Read More
Using google sheets query functions to filter a list for unique values...


google-sheetsgoogle-sheets-formulagoogle-query-language

Read More
Evaluate a Google Sheets math expression with formula...


google-sheetssumgoogle-sheets-formulamultiplicationgoogle-query-language

Read More
how to search for a cell and grab the next cell data...


google-sheetsfiltervlookupsumifsgoogle-query-language

Read More
How to retrieve the first row where the date is more recent than x...


google-sheetsgoogle-sheets-formulagoogle-query-language

Read More
Error Importrange Goes Horizontal not vertical (Google Sheet)...


google-sheetsgoogle-sheets-formulagoogle-query-language

Read More
How do I select multiple different counts with different where clauses in Google Sheets query langua...


arraysgoogle-sheetslambdagoogle-sheets-formulagoogle-query-language

Read More
Google Sheets - how to show sheet name in SELECT result of QUERY() function...


google-sheetsgoogle-sheets-formulagoogle-query-language

Read More
Google Query - Sort last column ASC where I don't know the number of columns...


google-sheets-formulagoogle-query-language

Read More
BackNext