Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

New posts in array-formulas

COUNTIF function if day of week is Tuesday

How to add and highlight rows on input of particular column in Google Sheet

ArrayFormula a Filter in a Join (Google Spreadsheets)

Difference between two dates expressed as years, months, days (in one column)

IsDate ArrayFormula

Why does this Google Sheets formula for the last non-empty cell in a column work?

How to create INDIRECT array string of multiple sheet references in Google Sheets?

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