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:
{“Sun”,”Mon”,”Tue”,”Wed”,”Thu”,”Fri”,”Sat”}
To enter this array, select seven cells in one row and then type the following (followed by pressing
Ctrl+Shift+Enter):
={“Sun”,”Mon”,”Tue”,”Wed”,”Thu”,”Fri”,”Sat”}
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:
{10;20;30;40;50;60}
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
Ctrl+Shift+Enter:
={10;20;30;40;50;60}
The following is another example of a vertical array; this one has four elements:
{“Widgets”;”Sprockets”;”Do-Dads”;”Thing-A-Majigs”}
To enter this array into a range, select four cells in a column, enter the following formula and then press
Ctrl+Shift+Enter:
={“Widgets”;”Sprockets”;”Do-Dads”;”Thing-A-Majigs”}
Two-dimensional arrays
A two-dimensional array uses commas to separate its horizontal elements and semicolons to separate its vertical
elements.
Other language versions of Excel may use characters other than commas and semi-
colons.
The following example shows a 3 x 4 array constant:
{1,2,3,4;5,6,7,8;9,10,11,12}
Search JabSto ::




Custom Search