Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

New posts in array-formulas

How to compare 2 arrays with unequal numbers of elements in Excel

excel array-formulas

In ARRAY_LITERAL, an Array Literal was missing values for one or more rows - indirect formula error in google spreadsheet

Spreadsheet formula to gather all matches into one cell

Calculation with values expressed in different units (KB, MB, GB)

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