Functions

Hi Matt, thanks for your query. Actually, an array is a multi-dimensional variable rather than an arrangement of functions. A table on a spreadsheet is an "array" of data which Excel can then process. Arrays are more commonly used in programming but one live example would be how Excel creates a Pivot table from raw data - it's creating and manipulating an array from your data in the background. Using arrays programmatically really speeds data processing up but unless you've an interest in VBA you won't really come across them using standard Functions in Excel.

Hope this helps,

Anthony