What does it really mean?
An array is a structure or container that holds a collection of items.
The reason arrays come up so often in Excel formulas is that arrays can be mapped directly toranges.
Arrays can be vertical, horizontal, or two-dimensional.
Vertical arrays have items separated with semicolons.
Horizontal arrays use commas.
Two-dimensional arrays use both commas and semicolons.
If I change a value manually, the corresponding cell updates.
Arrays like this - where all values are hardcoded - are called “array constants”.
Array constants are useful in many formulas, and we’ll see more examples later on in the course.
