Array formulas are a powerful tool in Excel. An array formula is a formula that works with an array, or series, of data values rather than a single data value.
www.cpearson.com