Search code examples
Extract a word between a word and a character in Google Sheets...


arraysregexgoogle-sheetsgoogle-sheets-formulaarray-formulas

Read More
Google Sheets ARRAYFORMULA count preceeding rows that meet condition...


regexif-statementgoogle-sheetsgoogle-sheets-formulaarray-formulas

Read More
If cell value contains value from list (wildcard match), retrieve data from a specific column...


regexgoogle-sheetsgoogle-sheets-formulaarray-formulasgs-vlookup

Read More
How to get the source of an ARRAY formula combined with QUERY in Google Sheets...


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

Read More
Using sum + countifs to count items across many (26 to be exact) tabs/sheets...


google-sheetssumgoogle-sheets-formulaarray-formulascounting

Read More
How to combine rows into one column based on boolean values in Google Sheets?...


arraysgoogle-sheetsgoogle-sheets-formulatransposearray-formulas

Read More
I want to exclude blanks in serial numbering...


if-statementgoogle-sheetsgoogle-sheets-formulaarray-formulascounting

Read More
Filter column with condition Google Sheets...


google-sheetsfiltergoogle-sheets-formulaarray-formulasgs-vlookup

Read More
Array subtraction in Google Sheets...


arraysgoogle-sheetsgoogle-sheets-formulaarray-formulas

Read More
Google Sheets Formula Update...


google-sheetsgoogle-sheets-formulaarray-formulasgoogle-sheets-querygs-vlookup

Read More
VLOOKUP which key is not the first column and multi conditions...


arraysgoogle-sheetsgoogle-sheets-formulaarray-formulasgs-vlookup

Read More
Mix 2 columns on Google spreadsheet...


arraysgoogle-sheetsgoogle-sheets-formulatransposearray-formulas

Read More
Find row in 2 columns where IF AND is meet between these 2 cells in respective row...


arraysif-statementgoogle-sheetsgoogle-sheets-formulaarray-formulas

Read More
Dynamic Dice Roller Spreadsheet using ArrayFormula...


arraysrandomgoogle-sheetsgoogle-sheets-formulaarray-formulas

Read More
adding sheet name when importing multiple sheets using importrange...


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

Read More
Comparing Multiple Values with AND using ARRAYFORMULA...


arraysgoogle-sheetsgoogle-sheets-formulaarray-formulas

Read More
Extract a string from long text to be used as a search key...


regexgoogle-sheetsgoogle-sheets-formulaarray-formulasgs-vlookup

Read More
Query particular row + remove X columns + and sum the rest in one formula?...


google-sheetstransposearray-formulasgoogle-sheets-querygoogle-query-language

Read More
How to use TEXT inside a QUERY in Google Sheets...


google-sheetsgoogle-sheets-formulaarray-formulasgoogle-sheets-querygoogle-query-language

Read More
How to split hours in a timesheet to account for working after midnight?...


datetimegoogle-sheetssumarray-formulasgoogle-sheets-query

Read More
How to get the difference of a MINUS/subtraction function in Google Sheets...


arraysgoogle-sheetsgoogle-sheets-formulaarray-formulassubtraction

Read More
How to stop upper() from being pulled through as part of Google Sheets QUERY?...


selectgoogle-sheetsarray-formulasuppercasegoogle-query-language

Read More
Subtracting from total if adjacent cell has content...


if-statementgoogle-sheetssumarray-formulasgoogle-sheets-query

Read More
ArrayFormula in google sheets SUM if values match criteria...


arraysgoogle-sheetsarray-formulas

Read More
Search columns for lowest value (in each row) and return header and value...


google-sheetsgoogle-sheets-formulaminarray-formulasgs-vlookup

Read More
Suming in an Array Formula using date based VLOOKUPs...


google-sheetssumarray-formulasgoogle-sheets-querygs-vlookup

Read More
Subtraction for two columns with arrayformula and isblank...


google-sheetsarray-formulas

Read More
Google Sheets ArrayFormula Countifs not working correctly...


google-sheetsgoogle-sheets-formulaarray-formulasrankingcountif

Read More
How do I sum values if both column, row and cell value match conditions?...


arraysgoogle-sheetssumarray-formulasgoogle-sheets-query

Read More
Excel SUMPRODUCT - how to deal with a #VALUE! error if array contains a text...


arraysexcelexcel-formulaarray-formulassumproduct

Read More
BackNext