Shanika has attended:
Excel Advanced course
Excel, Array formulae
When is it useful to use array formulae?
RE: Excel, Array formulae
Hi Shanika. Basically, you use an array formula whenever you want to perform a calculation based on a range of cells. The simplest array formula is, for example "=SUM(A1:A10)" in which those cell values are loaded into memory, added, and the result outputted into the formula cell. Arrays become even more important when programming, to perform functions on a (sometimes incredibly long) series of variables held in memory.
Hope this helps,
Anthony