google-sheets-formula Examples and Free Source Code

Sum of maximum quantity...

function google-sheets excel-formula google-sheets-formula formula

How to return only the latest entries from a list using QUERY function?...

google-sheets google-sheets-formula

Google Sheet Formula - Reformat data via cumulated formulas to have a specific table...

google-sheets google-sheets-formula

Google sheets custom function not working with an array...

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

sum a Google sheets column up to current row in arrayformula...

google-sheets lambda sum cumulative-sum google-sheets-formula

Searching/Filtering/Finding in Google Sheets...

google-sheets-formula

Is there a way to populate a dropdown category in Google Sheets using wildcard matches from another ...

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

How do I reference the current row in a vlookup?...

google-sheets google-sheets-formula spreadsheet

Google Sheets - Match two tabs with a constant - find another cell in matched row. Select those matc...

google-sheets google-sheets-formula

Sort by date with IMPORTRANGE in Sheets...

sorting google-sheets import google-sheets-formula google-query-language

Google Sheets vlookup to prioritize a column...

arrays google-sheets google-sheets-formula

How to Consolidate Data on a Log Using FILTER() Which Causes #REF Errors?...

google-sheets google-sheets-formula

pivot returning blank instead of 0 google sheet...

google-sheets google-sheets-formula vlookup

Complex Cocatenation in gsheets...

google-sheets google-sheets-formula

How to sync two sheets with =IMPORTRANGE() in two Google Spreadsheets?...

google-sheets google-sheets-formula

How to use AND operator in Google Sheets IMPORTXML XPath?...

google-sheets web-scraping xpath google-sheets-formula

Formula parse error after “setformula” in google sheets...

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

Get Customer Data from Sheet where Data in one sheet equals data in another sheet...

google-sheets google-sheets-formula

Google Sheets QUERY IMPORTRANGE is merging first and second rows...

google-sheets google-sheets-formula

Calling specific columns by header name in Query with ImportJson function in sheets...

google-sheets import google-sheets-formula

Is there a way to convert a given table to another table in excel/google sheets using a combination ...

excel google-sheets excel-formula google-sheets-formula

What is the Google Sheets formula to calculate the working hours for each specific day based on the ...

google-sheets timestamp google-sheets-formula date-difference ticket-system

Multiple columns in QUERY with "and" in Google Sheets...

google-sheets google-sheets-formula

Return last value based on date with criteria on google sheets...

google-sheets google-sheets-formula

How to use FILTER to return a range with no blanks...

google-sheets google-sheets-formula

How to reconcile monthly expected vs actual amounts using query and vlookup?...

google-sheets-formula vlookup

Google sheets to get stock data on a specific date...

google-sheets google-sheets-formula

How to stack different columns from a query into one single column Google Sheets...

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

Google sheet query error: "Result too large". How to fix?...

google-sheets google-sheets-formula

How to use FILTER function to extract data from not exact matches?...

google-sheets google-sheets-formula