Microsoft Office Tutorials and References
In Depth Information
To display this array in a range requires 12 cells. To enter this array into a range, select a range of cells that con-
sists of three rows and four columns. Then type the following formula and then press Ctrl+Shift+Enter:
Figure 14-3 shows how this array appears when entered into a range (in this case, B3:E5).
Figure 14-3: A 3 x 4 array entered into a range of cells.
If you enter an array into a range that has more cells than array elements, Excel displays #N/A in the extra cells.
Figure 14-4 shows a 3 x 4 array entered into a 10 x 5 cell range.