Excel 2010 Bible

Part II: Working with Formulas and Functions

370

FIGURE 16.12

Using the TRANSPOSE function to transpose a rectangular array.

Generating an array of consecutive integers .............................................................

As you see in Chapter 17, generating an array of consecutive integers for use in an array formula is

often useful. The 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:

{=ROW(1:12)}

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 one column and enter the array formula into the range.

You’ll find that the range is filled with 12 consecutive integers (as shown in Figure 16.13).

FIGURE 16.13

Using an array formula to generate consecutive integers.