Reference: The cell or range of cells or range of cells for which you want to return the column number. It is optional. Array: An array or array formula, or a reference to a range of cells for ...
This type of array is like a table, with data held in rows and columns. The following array would hold ten scores for two players. The first player (0) has data stored in the first row.