Search code examples
Google Apps Script - use query to combine 2 sheets but fail to get the complete...


arraysgoogle-sheetsstring-formattingnumber-formattinggoogle-query-language

Read More
Adding an additional row of data based on condition - Google Sheets...


arrayssortinggoogle-sheetsuniquegoogle-query-language

Read More
Display Upcoming Dates By This Week, Next Week and Next Month on a separate sheet...


google-sheetsfiltertransposeflattengoogle-query-language

Read More
Unable to parse query string for Function QUERY parameter 2: PARSE_ERROR: Encountered " <ID&...


arraysgoogle-sheetsconcatenationgoogle-query-languagetextjoin

Read More
Assigning an number to beside a data validation source...


if-statementgoogle-sheetssumgoogle-sheets-formulagoogle-query-language

Read More
How to add condition to Array to concatenate Columns A&B only if Column B value is not blank?...


concatenationgoogle-sheets-formulaflattengoogle-query-languagetextjoin

Read More
Exclude lines if ref and grade match in another sheets...


google-sheetsfiltertransposeflattengoogle-query-language

Read More
Finding duplicates across range and summing it up...


google-sheetsgoogle-sheets-formulavlookupgoogle-query-languageindex-match

Read More
How to ignore text with GSheets Query dateDiff function?...


google-sheetsdatediffgoogle-query-language

Read More
Which formulas support characters like the "&" "|" " * "...


arraysregexgoogle-sheetsgoogle-sheets-formulagoogle-query-language

Read More
I need to get the answer that is 1 above my query search...


google-apps-scriptgoogle-query-language

Read More
QUERY function with OR condition > Query Table, Select E where C contains Cell1 *OR* Cell2 limit ...


arraysgoogle-sheetsgoogle-sheets-formulavlookupgoogle-query-language

Read More
Google Sheets - Query Multiple Sheets That Have Different Structure...


arrayssumgoogle-sheets-formulavlookupgoogle-query-language

Read More
Using function as an arrayformula to calculate each row's data...


arraysgoogle-sheetssumvlookupgoogle-query-language

Read More
How to use Google Sheets to create table of Likert scale results grouped by counts...


sortinggoogle-sheetspivotgoogle-sheets-formulagoogle-query-language

Read More
Filter and Importrange not accepting multiple criteria in Google Sheets...


google-sheetsimportsumvlookupgoogle-query-language

Read More
How to using ABS equivalent in this query formula in Google Sheets?...


google-sheetsimportgoogle-sheets-formulauniquegoogle-query-language

Read More
Google Sheets (Formula or GAScript) - Combine 2 sheets with unique columns into a single sheet...


arraysregexgoogle-sheetsgoogle-sheets-formulagoogle-query-language

Read More
Splitting rows of data across multiple sheets within same workbook...


arraysgoogle-sheetslimitoffsetgoogle-query-language

Read More
Importrange & query import order is random and not below each other...


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

Read More
Can't get correct sums from data in a sheet either by sumif, sumifs, sumproduct or query...


arraysregexgoogle-sheetsgoogle-sheets-formulagoogle-query-language

Read More
google sheet ( name sheet )...


arraysimportgoogle-sheets-formulaformulagoogle-query-language

Read More
Sort Column header based on row value, and show as columns...


sortinggoogle-sheetsgoogle-sheets-formulaspreadsheetgoogle-query-language

Read More
Is it possible to average a value over the last 5 days based on criteria?...


google-sheetsgoogle-sheets-formulaflattengoogle-query-languagetextjoin

Read More
Explode each row into multiple rows by splitting a column of a given computed range...


google-sheetspivot-tablevlookupgoogle-query-languagetextjoin

Read More
Google sheets select field by maximum timestamp & specific cell value...


google-sheetstimestampmatchvlookupgoogle-query-language

Read More
Google Sheets: EXCLUDE hidden rows in query pulling unique data using indirect function...


arraysif-statementgoogle-sheetsuniquegoogle-query-language

Read More
Count Number of Consecutive Occurrence of values in Google sheets...


if-statementgoogle-sheetsvlookupcountifgoogle-query-language

Read More
Google Sheets: How to combine multiple rows in their own cells according to an ID?...


google-sheetspivotgoogle-sheets-formulagoogle-query-languagetextjoin

Read More
If or query, if criteria is met, copy from other sheet...


google-sheetsmatchvlookupgoogle-formsgoogle-query-language

Read More
BackNext