Search code examples
Table transformation Google Sheets...

if-statementgoogle-sheetstransposeflattengoogle-query-language

Read More
Googlesheets count single cell across multiple sheets...

arraysgoogle-apps-scriptgoogle-sheetscountifgoogle-query-language

Read More
Googlesheets Query to substract Sheets...

google-sheetssumgoogle-sheets-formulasumifsgoogle-query-language

Read More
Google Query - "NOT LIKE" Statement Doesn't work...

sqlgoogle-sheetsgoogle-sheets-formulagoogle-query-language

Read More
Google sheets beginners course overall amounts of products in stock formula...

regexgoogle-sheetssplitgoogle-sheets-formulagoogle-query-language

Read More
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
BackNext