Excel 2010 Bible

Part II: Working with Formulas and Functions

362

FIGURE 16.3

A 3 × 4 array entered into a range of cells.

FIGURE 16.4

A 3 × 4 array entered into a 10 × 5 cell range.

Naming Array Constants ...................................................................................................

You can create an array constant, give it a name, and then use this named array in a formula.

Technically, a named array is a named formula.

Cross-Reference
Chapter 3 covers the topic of names and named formulas. n

Figure 16.5 shows a named array being created from the New Name dialog box. (Access this dialog

box by choosing Formulas ➪ Defined Names ➪ Define Name.) The name of the array is

DayNames, and it refers to the following array constant:

{“Sun”,”Mon”,”Tue”,”Wed”,”Thu”,”Fri”,”Sat”}

Notice that, in the New Name dialog box, the array is defined (in the Refers To field) using a lead-

ing equal sign (=). Without this equal sign, the array is interpreted as a text string rather than an