Microsoft Office Tutorials and References
In Depth Information
Chapter 3 covers names and named formulas in detail.
To create a named constant array, use the New Name dialog box (choose Formulas ⇒ Defined Names ⇒ Define
Name). In Figure 14-5, the name of the array is DayNames, and it refers to the following array constant:
Figure 14-5: Creating a named array constant.
Notice that in the New Name dialog box, the array is defined by using a leading equal sign (=). Without this
equal sign, the array is interpreted as a text string rather than an array. Also, you must type the curly brackets
when defining a named array constant; Excel does not enter them for you.
After creating this named array, you can use it in a formula. Figure 14-6 shows a worksheet that contains a
single array formula entered into the range B2:H2. The formula is