Search code examples
How can I extract a specific substring from one cell using a list of specific values from a differen...


excelexcel-formulaarray-formulas

Read More
SUMPRODUCT+ARRAYFORMULA in Google Sheets...


google-sheetsgoogle-sheets-formulaarray-formulassumproduct

Read More
Use custom MD5 formula with ARRAYFORMULA...


google-apps-scriptgoogle-sheetsmd5array-formulascustom-function

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
digital TIX clock in Google Sheets...


google-sheetstimegoogle-sheets-formulaarray-formulasdigital

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
Add title row with ARRAYFORMULA in Google Sheets...


google-sheetsgoogle-sheets-apiarray-formulas

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


google-sheetsgoogle-sheets-formulavlookuparray-formulas

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 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
ARRAY_LITERAL, an Array Literal was missing values for one or more rows...


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

Read More
Combining multiple spreadsheets in one using IMPORTRANGE...


google-sheetsgoogle-sheets-formulaarray-formulasimportrange

Read More
ArrayFormula + multiple IMPORTRANGE + QUERY...


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

Read More
Get Link to this cell in Google sheets...


if-statementgoogle-apps-scriptgoogle-sheetshyperlinkarray-formulas

Read More
2D Lookup Returning the Associated Column Header Within an Array Formula...


google-sheetsgoogle-sheets-formulaarray-formulas

Read More
Fill empty cells with the same value as previous cell in Google Sheet (Array Formula)...


arraysgoogle-sheetsgoogle-sheets-formulavlookuparray-formulas

Read More
Arrayformula with sumifs and 1 static criteria...


google-sheetsarray-formulascriteriasumifs

Read More
How to see the +/-% change in rolling average between two cells?...


google-sheetsgoogle-sheets-formulaarray-formulascumulative-sum

Read More
How can I split comma separated strings and remove duplicates?...


google-sheetsgoogle-sheets-formulaarray-formulas

Read More
How can I rearrange a Google Sheet using the data within the sheet?...


google-sheetsgoogle-sheets-formulaarray-formulastranspose

Read More
Unpivot data in Google Sheets with Query Function...


google-sheetsgoogle-sheets-formulaarray-formulas

Read More
Use ArrayFormula to propagate row with specific formula...


google-sheetsgoogle-sheets-formulaarray-formulas

Read More
Is there any way to generate a pivot table only using formulas?...


google-sheetsgoogle-sheets-formulapivot-tablearray-formulas

Read More
Sheets Arrayformula: increment range size row by row...


google-sheetsrangearray-formulasauto-increment

Read More
How to extract multiple blocks of rows between two keywords in a Google Sheets column into adjacent ...


google-sheetsgoogle-sheets-formulaarray-formulas

Read More
ultimate short custom number formatting - K, M, B, T, etc., Q, D, Googol...


google-apps-scriptgoogle-sheetsstring-formattingarray-formulasnumber-formatting

Read More
BackNext