Embedded Files
ARRAYFORMULA is very open-ended, which allows it to be used for a wide variety of purposes and in combination with many other functions. This is the benefit of ARRAYFORMULA – it can be used to do almost anything to a large data set, all from one function!
How to use?
How to use?
SYNTAX: =ARRAYFORMULA(array_formula)
array_formula – this parameter can either be
a range
a mathematical expression using one cell range or multiple ranges of the same size, or
a function that returns a result greater than one cell
Page updated
Google Sites
Report abuse