Search code examples
How to sort rows in Google Sheets...


arrayssortinggoogle-sheetsgoogle-sheets-formulagoogle-sheets-query

Read More
How to delete rows that do not containing specific text within A column using Google Sheets App?...


google-apps-scriptgoogle-sheetsgoogle-sheets-query

Read More
Concat in Arrayformula using row numbers...


if-statementgoogle-sheetsgoogle-sheets-formulaarray-formulasgoogle-sheets-query

Read More
Arrayformula works for countifs but not sumifs?...


google-sheetsgoogle-sheets-formulaarray-formulasgoogle-sheets-querysumifs

Read More
Removing only blank cells (not rows) in Google Sheets...


google-sheetsconcatenationtransposearray-formulasgoogle-sheets-query

Read More
How to use REGEXEXTRACT only on rows that contain a cell which contain a string within a SUM?...


regexgoogle-sheetssumarray-formulasgoogle-sheets-query

Read More
Transpose GROUPS of QUERY results to single column...


google-sheetsgoogle-sheets-formulatransposearray-formulasgoogle-sheets-query

Read More
In Google Sheets or Excel, how do I search for values that are similar?...


excelexcel-formulagoogle-sheetsgoogle-sheets-query

Read More
Find Row Where Sum is Reached from Single Joined Column (not a range of cells)...


google-apps-scriptgoogle-sheetsgoogle-sheets-formulagoogle-sheets-query

Read More
Replacing cell specific seperator in Google Sheets - 21.06.2019 to 21/06/2019...


arraysdategoogle-sheetsarray-formulasgoogle-sheets-query

Read More
Get the last 5 results of column C or D if column A or B is equal to ___?...


if-statementgoogle-sheetsaveragearray-formulasgoogle-sheets-query

Read More
Query/filter by 3 AND criteria + countif...


dategoogle-sheetsgoogle-sheets-formulagoogle-sheets-querygoogle-query-language

Read More
Filter row and populate...


arraysgoogle-sheetsgoogle-sheets-formulaarray-formulasgoogle-sheets-query

Read More
Sort by Column C but group the values from Column F...


google-sheetsgoogle-sheets-formulagoogle-sheets-querygoogle-query-language

Read More
Google Sheets, how to subtract one array from another?...


arraysgoogle-sheetssumarray-formulasgoogle-sheets-query

Read More
Dropdown query has no error, but returns no results...


if-statementgoogle-sheetsgoogle-sheets-formulagoogle-sheets-querygoogle-query-language

Read More
Concatenate two cells together on an import query...


arraysgoogle-sheetsarray-formulasgoogle-sheets-querygoogle-query-language

Read More
Creating a dynamically sorted and filtered list from a range using a single formula in Google Sheets...


sortinggoogle-sheetsfilteringarray-formulasgoogle-sheets-query

Read More
Extracting and counting unique word frequency from a range...


google-sheetsgoogle-sheets-formulaarray-formulascountinggoogle-sheets-query

Read More
Use limits with numerical cell reference in Google Sheets Query...


limitgoogle-sheets-query

Read More
How to compare Individual data to aggregate group by in Google Query (SQL)?...


google-sheetsgoogle-sheets-formulaarray-formulasgoogle-sheets-querygoogle-query-language

Read More
Google Sheets import range returning incorrect data...


google-sheetsgoogle-sheets-formulagoogle-sheets-querygoogle-query-languageimportrange

Read More
In Google Sheets, how can one aggregate values (MAX, MIN, AVERAGE) based on the result of splitting ...


google-sheetsgoogle-sheets-formulatransposearray-formulasgoogle-sheets-query

Read More
Summarizing data from multiple sheets...


google-sheetsgoogle-sheets-formulatransposegoogle-sheets-querygoogle-query-language

Read More
Pulling a range based on one criteria...


google-sheetsgoogle-sheets-formulaarray-formulasgoogle-sheets-querytextjoin

Read More
Get all the timestamp values from a range, within the past 24 hours...


google-sheetsgoogle-sheets-formulaarray-formulasgoogle-sheets-querygoogle-query-language

Read More
Google Sheets query in arrayformula acting as SUMIFS...


google-sheetsgoogle-sheets-formulaarray-formulasgoogle-sheets-querysumifs

Read More
Google Sheet - Combine two tables dynamically including duplicates...


google-apps-scriptgoogle-sheetsgoogle-sheets-formulagoogle-sheets-query

Read More
Google sheets query functions: how to do arithmetic on columns with non-constants, i.e. dividing not...


google-sheetsaveragegoogle-sheets-formulagoogle-sheets-queryarithmetic-expressions

Read More
What is, if any, the mid() function equivalent for a 1 dimension range/array, instead of a string?...


arraysgoogle-sheetsgoogle-sheets-formulaoffsetgoogle-sheets-query

Read More
BackNext