Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Array Formula Not Working with Range with Formulas | Excel Discussion (Misc queries) | |||
Array formula returning wrong results | Excel Discussion (Misc queries) | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) |