Formulas

The syntax for storing a formula in a name is the same as for a range because the range is, in essence, a formula:

RefersTo:="=OFFSET(Sheet2!A2,0,0,COUNTA(Sheet2!$A:$A))"

The preceding line of code allows for a dynamic named column, which is very useful in creating dynamic tables or referencing any dynamic listing on which calculations may be performed, as shown in Figure 7.5.

Figure 7.5

Dynamic formulas can be assigned to names.

Figure 7.5

Dynamic formulas can be assigned to names.

0 0

Post a comment