Array formulae are a special type of Excel formula that return values across a range of cells.

TBC