google-sheets-formula Examples and Free Source Code

Distribute a quantity among multiple requirements based on criteria...

if-statement google-sheets indexing lambda google-sheets-formula

How do I get the column letter of a single row where a particular value equals a test value?...

google-sheets google-sheets-formula spreadsheet

ArrayFormula of Resetting Running Total in Google Sheets...

google-sheets sum google-sheets-formula array-formulas cumulative-sum

Repeat the higher numbers (>1) on column ($AE$3:$AE) depends how many the duplicate names are in ...

google-sheets google-sheets-formula formula spreadsheet array-formulas

Query two sheets and output on third...

google-sheets google-sheets-formula

ImportXML using Google Spreadsheets and Save Results Over-Time...

google-apps-script google-sheets web-scraping triggers google-sheets-formula

YouTube imported data in Google Sheets (IMPORTXML fnc) has stopped working...

google-sheets web-scraping google-sheets-formula youtube-data-api

Finding ImportJSON Query Path in Google Sheets...

google-apps-script google-sheets google-sheets-formula

Copy results of a query function from one worksheet and append it at the end of another worksheet in...

google-apps-script google-sheets google-sheets-formula macro-recorder

SUM on multiple dynamic criteria on a separate sheet in google sheets...

google-sheets filter lambda sum google-sheets-formula

How do I add formulas to Google Sheets using Google Apps Script?...

google-apps-script google-sheets google-sheets-formula

vlookup several criteria and a range...

google-sheets filter google-sheets-formula vlookup google-query-language

how to get unique values with excluding particular value in google sheet...

google-sheets google-sheets-formula

vlookup most recent entry/last row where it finds value...

google-sheets google-sheets-formula vlookup

How to create array dynamically from a string without copy pasting?...

arrays google-sheets dynamic google-sheets-formula

Extract Jotform Product Data from Multi Line Cell in Google Sheets...

google-sheets google-sheets-formula jotform

Sheets/Excel " inside ""...

if-statement google-sheets filter google-sheets-formula vlookup

Trying to label rows in Google Sheets where there are duplicate values in one column in order of of ...

google-sheets duplicates google-sheets-formula

How to get YouTube channels' topic categories in bulk with Google Apps Script?...

google-apps-script google-sheets google-sheets-formula youtube-data-api

How to compare the number of matching words in two cells? Excel / Google Sheets...

excel-formula google-sheets-formula

Google Sheets ArrayFormula with CountA and Filter...

google-sheets lambda google-sheets-formula countif flatten

Function ARRAY_ROW parameter 2 has mismatched row size...

google-sheets google-sheets-formula

Return TRUE if two conditions are met but one of them has two options...

google-sheets google-sheets-formula spreadsheet

Disable Google Sheets formula...

google-apps-script google-sheets google-sheets-formula

Concat row/column headers for all positive fields in sparse matrix?...

sorting if-statement google-sheets-formula flatten textjoin

How to use AND in Google sheets?...

google-sheets google-sheets-formula

Using Arithmetic Operators for null values in GSheets Query Function...

google-sheets google-sheets-formula google-query-language

Why is Google Sheets query not suppressing header, when there's a calculated field?...

google-apps-script google-sheets google-sheets-formula google-visualization google-query-language

How to avoid repeating multiple arguments to AND function for a contiguous range?...

google-sheets google-sheets-formula operators

How to use arrayformula with formulas that do not seem to support arrayformulas?...

google-sheets google-sheets-formula array-formulas