Search code examples
Highlight duplicates in every 3rd column in Google Sheets...


google-sheetsgoogle-sheets-formula

Read More
how to get update-able sheet name in google sheets...


if-statementgoogle-sheetsreferencegoogle-sheets-formulagsheets

Read More
Generate unique random numbers in Google Sheets...


google-sheetsrandomgoogle-sheets-formula

Read More
How to calculate value based on tax bracket using Google Sheets formula?...


google-sheetsgoogle-sheets-formula

Read More
how to compute MD5 hash in Google Sheets using a single formula?...


if-statementgoogle-sheetshashgoogle-sheets-formulamd5

Read More
SUMPRODUCT+ARRAYFORMULA in Google Sheets...


google-sheetsgoogle-sheets-formulaarray-formulassumproduct

Read More
In a google sheets query, replace all diacritic caracters with a formula...


google-sheetsgoogle-sheets-formula

Read More
Remove diacritics via formula on Google Sheets (Part 2)...


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

Read More
Array formula with matrix decision...


google-sheetsgoogle-sheets-formulaarray-formulas

Read More
Add comments/description inside a formula...


google-sheetsgoogle-sheets-formula

Read More
Filter a range by array...


filtergoogle-sheetsgoogle-sheets-formula

Read More
Repeat the rows based on the Number of Splitted Values on a Certain Cell...


google-sheetsgoogle-sheets-formula

Read More
digital TIX clock in Google Sheets...


google-sheetstimegoogle-sheets-formulaarray-formulasdigital

Read More
Using a Named Range to identify worksheets to use a SUMIFS on a to add an array of data...


google-sheetsgoogle-sheets-formulasumifsnamed-rangesnamed

Read More
Adding sheet name as column to query in Google Sheets...


sqlgoogle-sheetsgoogle-sheets-formulaarray-formulasgoogle-sheets-query

Read More
how to get List of GID numbers and List of Sheet Names in Google Sheets?...


arraysgoogle-sheetsgoogle-sheets-formulaarray-formulaslet

Read More
Stacking Multiple Arrays In Query/Lambda Function...


google-sheetslambdaimportgoogle-sheets-formulaarray-formulas

Read More
Google Sheets VLOOKUP across Mismatched Ranges in Multiple Sheets...


google-sheetsgoogle-sheets-formulavlookuparray-formulas

Read More
Inserting a table of variable length in the middle of a spreadsheet - how to make spreadsheet dynami...


arraysgoogle-sheetsfiltergoogle-sheets-formula

Read More
How do I return a string that the built in Google Spreadsheet function can us...


google-apps-scriptgoogle-sheetsgoogle-sheets-formulaarray-formulasgoogle-sheets-query

Read More
How to import data from multiple sheets into one sheet with BYROW and LAMBDA?...


google-sheetsgoogle-sheets-formula

Read More
Reverse columns of spreadsheet...


arraysgoogle-sheetsgoogle-sheets-formula

Read More
How do I get the formula separator in a script?...


javascriptgoogle-apps-scriptgoogle-sheetslocalegoogle-sheets-formula

Read More
How do I group multiple tab ranges in array literal dynamically(by using wildcard)?...


javascriptgoogle-apps-scriptgoogle-sheetsgoogle-sheets-formulaarray-formulas

Read More
Google Sheets query (SELECT A WHERE B <> '0')...


google-sheetsgoogle-sheets-formulaarray-formulas

Read More
Google Sheets: How do I create an array from a range, adding a column with a constant literal value ...


google-sheetsgoogle-sheets-formula

Read More
ARRAY_LITERAL, an Array Literal was missing values for one or more rows...


google-sheetsgoogle-sheets-formulaarray-formulasgoogle-sheets-queryimportrange

Read More
Need SUMIFS to return multiple rows...


google-sheetsgoogle-sheets-formulasumifs

Read More
Adding Values to a Column in FILTER() on Google Sheets...


google-sheetsgoogle-sheets-formula

Read More
Google Sheets ARRAY_ROW issue with sorting a pass-through LAMBDA. Additional empty rows cause formul...


google-sheetslambdagoogle-sheets-formula

Read More
BackNext