Microsoft Office Tutorials and References
In Depth Information
Figure 14-12: Using the TRANSPOSE function to transpose a rectangular array.
You can, of course, use the TRANSPOSE function to transpose an array stored in a range. The following for-
mula, for example, uses an array stored in A1:C4 (four rows, three columns). You can enter this array formula
into a range that consists of three rows and four columns:
Generating an array of consecutive integers
As you will see in Chapter 15, it's often useful to generate an array of consecutive integers for use in an array
formula. Excel's ROW function, which returns a row number, is ideal for this. Consider the array formula
shown here, entered into a vertical range of 12 cells:
This formula generates a 12-element array that contains integers from 1 to 12. To demonstrate, select a range
that consists of 12 rows and 1 column, and then enter the array formula into the range. You'll find that the range
is filled with 12 consecutive integers (see Figure 14-13).