Скачать или смотреть Array Formula

If you understand how array formulas work, you understand the true beauty and power of
Excel formulas
Introducing Array Formulas
One of Excel's most interesting (and most powerful) features is its ability to work with arrays in formulas
As you'll see, arrays don't have to be stored in cells.You can also work with arrays that exist only in Excel's memory
Single-cell array formulas: Work with arrays stored in ranges or in memory and produce a result displayed in a single cell.
Multi cell array formulas: Work with arrays stored in ranges or in memory and produce an array as a result. Because a cell can hold only one value, a multi cell array formula is entered into a range of cells.
To become an Excel power user, you need to know how to use array formulas
Create array formulas
This chapter helps you understand array formulas in Excel