An array is a data structure consisting of one or more values, which is processed as a single object.
Arrays can consist of:
–Range of cells
–Manually entered set of values
–Result of calculating a formula
There are three main types of arrays:
–One-dimensional: A sequence of values arranged in a single row or column.
–Two-dimensional: Tables of values consisting of several rows and columns.
–Dynamic: The result of formulas that are automatically updated when the source data changes.
According to the method of creation, arrays are divided into:
–Static: Created manually by the user.
–Dynamic: Generated automatically through formulas.
An array formula is a special type of formula that allows you to perform multiple calculations on ranges of data simultaneously. Unlike regular formulas, array formulas work with all values in the specified ranges at once.
There are two main types of array formulas:
–Single cell formulas are array formulas, the result of which is displayed in a single cell. Example: Summing up the products of two columns =SUM(A1:A10*B1:B10)
–Multicell formulas are array formulas, the results of which are displayed in several cells. Example: Multiplying the values of two columns with the output of the results in a separate range =A1:A3 + B1:B3 → {A1+B1; A2+B2; A3+B3}.