* Array Formulas

Array Formulas.. Now this might be the first time most of you are reading about it.... So what is an Array formula…??

An array formula is a formula that can perform multiple calculations on one or more of the items in an array. Array formulas can return either multiple results or a single result. Its like a small program in itself one which can have loops/ iterations and do calculations which can not be achieved using normal formulas.

- Karthik