Array formulae formulas allow you to perform laborious calculations on sets of data without having to do the intermediary stages in columns or rows of Excel. Using them makes the spreadsheet smaller and faster, but the formulae formulas need to be checked carefully for mistakes.
...