Name a formula producing an array
I defined a name that was equated to an array of values returned by a
function. After typing the definition, I tried pressing ctrl-shift-enter.
The function works properly, but I don't see the definition in braces {}
when selecting the name (in the Define Name dialog box).
Can a name be entered as an array? Reducing calculation time is the name of
the game here.
|