Search code examples
Get related data from other tab as an array for summary in other tab...

dategoogle-sheetsgoogle-sheets-formulaaveragegoogle-query-language

Read More
Google Sheets GROUPBY Query that combines values into one cell to satisfy grouped columns...

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

Read More
How to create a comma separate aggregate in Google Sheets?...

google-sheetsjoinsplitflattengoogle-query-language

Read More
How to generate a monthly report using 1 formula at A2...

google-sheetspivotgoogle-sheets-formulaspreadsheetgoogle-query-language

Read More
How to return nth value from one Column based on another Column using ArrayFormula or QUERY?...

google-sheetsfiltercountvlookupgoogle-query-language

Read More
Determine the number of terms by year in Google Sheets...

arraysfiltercountgoogle-sheets-formulagoogle-query-language

Read More
My Query function keeps returning a #VALUE error and I can't figure out what I'm doing wrong...

arraysgoogle-sheetsgoogle-sheets-formulaformulagoogle-query-language

Read More
How to sum results obtained with VLOOKUP and IMPORTRANGE in Google Sheets?...

google-sheetssplitformulaflattengoogle-query-language

Read More
Lookups based on criteria across sheets...

arraysgoogle-sheetspivotvlookupgoogle-query-language

Read More
google sheets additional custom column in filter...

google-sheetsfiltergoogle-sheets-formulasequencegoogle-query-language

Read More
How to get max values for each unique value in a different column in Google Sheets?...

arrayssortinggoogle-sheetsmaxgoogle-query-language

Read More
Google Sheets: Adding images to queried cells...

imagegoogle-sheetsfiltermatchgoogle-query-language

Read More
Find lowest value matched from an Index/Match of an array...

arraysgoogle-sheetsvlookupmingoogle-query-language

Read More
Combine rows of varying length google sheets...

arraysgoogle-sheetstransposeflattengoogle-query-language

Read More
If statements within a Query...

arraysgoogle-sheetsfilterimportgoogle-query-language

Read More
Build List with Attached Items...

google-sheetssplittransposeflattengoogle-query-language

Read More
ImportXML not expanded as would overwrite data...

arraysgoogle-sheetsgoogle-sheets-formulaflattengoogle-query-language

Read More
Google Sheets - Query Pivot - show all results...

google-sheetspivot-tablesequenceflattengoogle-query-language

Read More
Choose function return 2 columns on Google Sheets...

arraysgoogle-sheetsgoogle-sheets-formulavlookupgoogle-query-language

Read More
How to QUERY with formating individual letters?...

google-sheetssyntaxreferencestring-formattinggoogle-query-language

Read More
How do you populate a google sheets/excel column with cells from a column in another sheet in the sa...

arrayssortinggoogle-sheetstimestampgoogle-query-language

Read More
Query formula not working with error AVG_SUM_ONLY_NUMERIC...

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

Read More
Google Sheets - countif with dynamic range...

google-sheetsgoogle-sheets-formulatransposeflattengoogle-query-language

Read More
How do I average the success metric of each word in message for over a hundred messages...

arraysgoogle-sheetsgoogle-sheets-formulaflattengoogle-query-language

Read More
Function to organise a table...

google-sheetsspreadsheettransposeflattengoogle-query-language

Read More
How to match with common cities visited in...

arraysif-statementgoogle-sheetsgoogle-sheets-formulagoogle-query-language

Read More
Pivot table vs formulas Google sheets...

arraysgoogle-sheetspivotpivot-tablegoogle-query-language

Read More
How to apply multiple criteria when using VLOOKUP+QUERY+IMPORTRANGE?...

arraysgoogle-sheetsimportgoogle-sheets-formulagoogle-query-language

Read More
Unable to parse query string for Function QUERY parameter 2: NO_COLUMN: A...

arrayssortinggoogle-sheetsgoogle-sheets-formulagoogle-query-language

Read More
Do not retrieve query if empty output...

functiongoogle-sheetsfiltergoogle-query-language

Read More
BackNext