Search code examples
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
Filter/Extract a text from excel sheet having similar values...


excelregexgoogle-sheetsexcel-formula

Read More
Set background color of cell based on text value...


google-sheets

Read More
Conditional formatting with custom formula skipping an empty cell...


google-sheets

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
Google Sheets API PivotFilter.getFilterCriteria yields "Service error: Spreadsheets" when ...


google-sheetsgoogle-apps-script

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


google-sheetsgoogle-sheets-formula

Read More
TextRotation angle is never set in Google Sheet API...


google-sheetsgoogle-apigoogle-sheets-apigoogle-api-java-client

Read More
MySQL Error: Unhandled exception: 'ascii' codec can't decode byte 0xef in position 0: or...


mysqlgoogle-sheets

Read More
digital TIX clock in Google Sheets...


google-sheetstimegoogle-sheets-formulaarray-formulasdigital

Read More
Find last cell with data for specific "search key" in google sheets...


google-sheetsgoogle-forms

Read More
run script if Date_1 > Date_2...


javascriptgoogle-apps-scriptgoogle-sheets

Read More
Using cell value as reference to sheet in formulas...


dategoogle-sheetsimportrange

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 Spreadsheet: Skip empty queries when stacking multiple queries in one sheet...


mysqlgoogle-sheets

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
Array Formula Sort, Query with headers...


google-sheetsgoogle-forms

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 can I merge multiple tabs in a Google Spreadsheet using Google App Script?...


google-apps-scriptgoogle-sheets

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
Joining ( {} ) 2 separately working queries gives a value error...


sqlgoogle-apps-scriptgoogle-sheetsformulagoogle-query-language

Read More
Count number of pairs, triplets, etc in a google spreadsheet...


google-sheets

Read More
Concatenate a range of cells with a comma...


arraysgoogle-sheetsjoingoogle-query-languagetextjoin

Read More
BackNext