Below is a quick video demonstration on Microsoft Excel Array Formulas.
Arrays, simply put, are a collection of data. For example you may have a column of data in an Excel document.
All those values, in range C2:C27, are a collection of data or an array of data. An array...