Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

New posts in google-sheets-formula

How to use the SUMIFS function in an ARRAYFORMULA, matching two criteria, to avoid copying down?

How to remove string between multiple sets of parentheses with regexreplace?

Trigger importHTML in Google Apps Script

Colouring cells in conditional formatting by the content in a neighbouring cells in Google Sheets

Give the named function argument a default value if not specified

Formula to display values in one column that do NOT appear in another column

How To Copy Formulas Only In Google Sheets (without values or formatting) in few steps?

Google Sheets: How do I create an array from a range, adding a column with a constant literal value in every row?

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

Data Validation Dropdown With Filtered Data Range

Select the difference between two times in QUERY

Formula to get next instance of row that contains specific text that works in ARRAYFORMULA

Google sheets split with regex or regexextract?

How do I format a Google Sheets duration formatted cell to show days, hours and minutes in a human readable format?

Google Sheets sum of columns where cell value matches multiple columns in another sheet

Removing all quotations marks from a string (REGEXREPLACE)

VLOOKUP returning wrong row

How to call library function as custom function from spreadsheet formula?

Autofil columns in one sheet from another only if columns have data AND a specific column has a specific value in Google Sheets

Append check function with _Strict?