An array is a group of cells or a range that are somehow related. This is needed when the user wants to perform a function that requires referencing multiple locations, or an array.

In microsoft excel, you can initiate an array formula by typing out the formula and hitting crtl + shft + enter

history | show excerpt | excerpt history