An array formula is a formula that can perform multiple calculations on one or more elements of an array. You can think of a table as a row or column of values, or as a combination of rows and columns of values. Array formulas can return either multiple results or a single result.
What is the purpose of array formula in Excel?
An array formula allows you to perform multiple calculations at once, or perform one or more calculations within a selected range of cells multiple times. The values referenced by these formulas can appear as values in a row, in a column, or in a matrix (rows and columns).
What is the difference between a range and an array?
An array is an object that is a collection of any elements. A range is an object that has a beginning and an end and can move from beginning to end without having to enumerate all the elements in between.