Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

New posts in array-formulas

Add title row with ARRAYFORMULA in Google Sheets

Is it possible to set a default value of zero when using COUNTA function in Google Sheets?

How can I use the OFFSET() formula with a range of values?

Google finance as an argument for ArrayFormula

Multiple criteria for sumif in Google Sheets

vlookup with multiple columns

How to use ARRAYFORMULA + FILTER within Google Spreadsheet?

Is there a Google Sheets or MS Excel formula to convert a column with JSON array to multiple rows

iterate row by row COUNTIF using ArrayFormula on Google Sheets

ArrayFormula is breaking the getLastRow() funtion. Possible workarounds?

How to get min value in a group?

Google Spreasheet QUERY Function to Something I can use in ARRAYFORMULA

ArrayFormula that refers to the previous row? (Circular dependency error)

ArrayFormula column disappears when sorting in a filter view in Google Sheets

How to use Excel's array-formulas for a UDF to read each cell correctly?

excel array-formulas vba

Using MIN/MAX in excel array formula

excel max min array-formulas

How to use CONCAT in QUERY?

find all array formulas in an excel worksheet

excel vba array-formulas

How to prefix Plus sign "+" before the number if the value is negative in Google Sheets or MS Excel?