Microsoft Office Tutorials and References
In Depth Information
The following example is another horizontal array; it has seven elements and is made up of text strings:
To enter this array, select seven cells in one row and then type the following (followed by pressing
One-dimensional vertical arrays
The elements in a one-dimensional vertical array are separated by semicolons. The following is a six-element
vertical array constant:
Displaying this array in a range requires six cells in a single column. To enter this array into a range, select a
range of cells that consists of six rows and one column. Then enter the following formula and press
The following is another example of a vertical array; this one has four elements:
To enter this array into a range, select four cells in a column, enter the following formula and then press
Two-dimensional arrays
A two-dimensional array uses commas to separate its horizontal elements and semicolons to separate its vertical
Other language versions of Excel may use characters other than commas and semi-
The following example shows a 3 x 4 array constant:
Search JabSto ::

Custom Search