Search code examples
Use a formula to organize columns with different amounts of data...


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

Read More
Finding a min() value on each row using an arrayformula() within Google Sheets...


google-sheetsgoogle-sheets-formulaminarray-formulasgoogle-sheets-query

Read More
Is it possible to implement multi-stage SORT using QUERY?...


arraysgoogle-sheetsgoogle-sheets-formulagoogle-sheets-querygoogle-query-language

Read More
Can I modify one spreadsheet document (google sheets) based on information from a separate spreadshe...


google-sheetssumarray-formulasgoogle-sheets-queryimportrange

Read More
Custom aggregation of Finance data in Google sheets...


google-sheetsgoogle-sheets-formulaarray-formulasgoogle-sheets-querygoogle-finance

Read More
Filter a range created dynamically via QUERY in Google Sheets...


arrayssortinggoogle-sheetsgoogle-sheets-formulagoogle-sheets-query

Read More
Google Sheets formula: extend single item in arrayformula...


arraysgoogle-sheetsfilterarray-formulasgoogle-sheets-query

Read More
Transform one to many data to columns...


google-sheetspivotarray-formulascountifgoogle-sheets-query

Read More
Grouping by Name in Query Formula not working...


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

Read More
Create rows from combination of other rows...


google-sheetsgoogle-sheets-query

Read More
FILTER 2 columns into one with NOT(ISBLANK)...


google-sheetsfiltergoogle-sheets-formulagoogle-sheets-querygoogle-query-language

Read More
Reversing a column when calculating slope for a line chart in Google Sheets...


if-statementgoogle-sheetsarray-formulasgoogle-sheets-querysparklines

Read More
Search for lowest/highest value in the date array...


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

Read More
How to calculate symmetric difference in Google Spreadsheets...


google-sheetsfiltergoogle-sheets-formulacountifgoogle-sheets-query

Read More
Collapse address fields for account statement...


arraysgoogle-sheetsgoogle-sheets-formulagoogle-sheets-querygoogle-query-language

Read More
I want to populate a new range by inserting numbers between already populated range based on adjusac...


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

Read More
Sum of matrix values, conditional, with infinite rows and columns...


google-sheetssumgoogle-sheets-formulaarray-formulasgoogle-sheets-query

Read More
Expand/explode a Google Sheets table with ticket open and close stats to show all tickets open each ...


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

Read More
combining FILTER formula in Google Sheets...


arraysgoogle-sheetsfiltergoogle-sheets-formulagoogle-sheets-query

Read More
Making query return rows that meet the criteria of a drop down in google sheets...


google-sheetsdropdowngoogle-sheets-formulagoogle-sheets-querygoogle-query-language

Read More
Google Sheets Query > Filter rows based on text in a string...


regexgoogle-sheetsfiltergoogle-sheets-formulagoogle-sheets-query

Read More
Add email address to sheet once Google form is submitted...


if-statementgoogle-sheetsgoogle-formsarray-formulasgoogle-sheets-query

Read More
Combining hlookup and vlookup...


google-sheetsgoogle-sheets-formulagoogle-sheets-querygs-vlookupimportrange

Read More
How do i get google sheets add up the hours by automatically selecting the correct date range (Monda...


google-sheetssumgoogle-sheets-formulagoogle-sheets-querygoogle-query-language

Read More
Using google sheets query to determine the amount of days an Id is offline during each month...


google-sheetsgoogle-sheets-query

Read More
How to copy data validation in a relative way, specifically list from range (with or without scripts...


spreadsheetgoogle-sheets-apigoogle-sheets-querygoogle-apps-script-editor

Read More
Join four columns into one according to each row...


arraysgoogle-sheetsgoogle-sheets-formulatransposegoogle-sheets-query

Read More
How to skip a column when using array formula to generate content in Google Sheets?...


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

Read More
How to (SUM(IF(REGEXMATCH(IMPORTRANGE with multiple criteria/conditions?...


regexgoogle-sheetsgoogle-sheets-formulaarray-formulasgoogle-sheets-query

Read More
How to count from an entire different google sheet for only one cell?...


google-sheetscountinggoogle-sheets-querygoogle-sheets-formula

Read More
BackNext