Search code examples
Google Sheets, Array Formula to merge 2 Sheets into one, and append a new column to specify which sh...


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

Read More
Customizing order of joined cell + header values when cell value isn't blank in Google Sheets (1...


arraysgoogle-sheetsgoogle-sheets-formulaflattengoogle-query-language

Read More
Reference a global query as data within subsequent queries?...


arraysgoogle-sheetssyntaxgoogle-sheets-formulagoogle-query-language

Read More
Survey completness problems in Google Sheets...


if-statementgoogle-sheetsconditional-statementsgoogle-sheets-formulagoogle-query-language

Read More
Substitute formula retrieving less data table...


arraysgoogle-sheetsgoogle-sheets-formulaflattengoogle-query-language

Read More
Variable for joining a header value AND/OR a delimeter to ordered values in Google Sheets (1B)...


google-sheetsgoogle-sheets-formulaflattengoogle-query-languagetextjoin

Read More
Sort multi-line cells containing dates in descending order in Google Sheets...


arraysgoogle-sheets-formulaflattengoogle-query-languagetextjoin

Read More
Google Sheets - Flattening a table into two columns, but returning results based on varying conditio...


arraysgoogle-sheetsgoogle-sheets-formulaflattengoogle-query-language

Read More
Adding Columns using google sheets...


dategoogle-sheetsimportformulagoogle-query-language

Read More
Is there a formula that will count the number of terms in a mathematical equation in Google Sheets o...


excel-formulasumgoogle-sheets-formulastring-formattinggoogle-query-language

Read More
SQL exact match in query for Google Sheets...


google-sheetsfiltergoogle-sheets-formulamatchgoogle-query-language

Read More
Form submissions over time - compare the difference from last submission - Google Sheets...


google-sheetsfiltertransposeflattengoogle-query-language

Read More
Reading a cell text as a Formula...


arraysgoogle-sheetssumspreadsheetgoogle-query-language

Read More
Join multiple columns horizontally into one column with ArrayFormula...


google-sheetsgoogle-sheets-formulatransposeflattengoogle-query-language

Read More
Conditional removal of rows in importhtml data output...


arraysweb-scrapinggoogle-sheets-formulasubstitutiongoogle-query-language

Read More
Google spreadsheet Query function parse error on 1 column...


arraysgoogle-sheetssyntaxgoogle-query-languagesingle-quotes

Read More
Google Sheets Query - Not like partial match...


arraysgoogle-sheetsgoogle-sheets-formulamatchgoogle-query-language

Read More
Using importrange with Sumifs in Google Sheets...


dategoogle-sheetsimportgoogle-sheets-formulagoogle-query-language

Read More
Transform a data table from column based data to list column headers by their unique table entries...


google-sheetspivot-tableflattengoogle-query-languagedata-transform

Read More
ROLLING date range in a Google Ads API Query...


google-ads-apigoogle-query-language

Read More
Combine query results vertically...


arraysif-statementgoogle-sheetsconcatenationgoogle-query-language

Read More
Compare two lists and print what is missing...


google-sheetsfiltercomparedifferencegoogle-query-language

Read More
Google sheet adding Serial number and calculation...


arraysgoogle-sheetsgoogle-sheets-formulaflattengoogle-query-language

Read More
Google Sheets - Find the lowest values in the entire table line by line...


google-sheetsminarray-formulasflattengoogle-query-language

Read More
Converting a 2D range into a 1D array with spaces in Google Sheets...


arraysgoogle-sheetsfilterflattengoogle-query-language

Read More
Expandable Importrange...


arraysgoogle-sheetsgoogle-sheets-formulagoogle-query-languagetextjoin

Read More
Google Sheet: Fetch earliest date and average of value of month from the list...


google-sheetsgoogle-sheets-formulaaveragenumber-formattinggoogle-query-language

Read More
Filtering out the first X non-empty cells in each row of a matrix...


google-sheetsvlookuptransposeflattengoogle-query-language

Read More
Average use based on number of times an email address appears within a period...


google-sheetscountsumaveragegoogle-query-language

Read More
Get related data from other tab as an array for summary in other tab...


dategoogle-sheetsgoogle-sheets-formulaaveragegoogle-query-language

Read More
BackNext