Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Creating an ARRAY UDF
Is it possible to create an ARRAY UDF with the sole purpose of
supporting arrays in nested formulas ? I'm trying to avoid the use of array entered formulas. I've successfully rewritten array entered formulas using functions like SUMPRODUCT and noticed a remarkable decrease in calculation time. However, I've noticed that SUMPRODUCT only supports creating an array with the first function to the right of the first (. The purpose of the ARRAY UDF would be to maintain arrays throughout a formula that is deeply nested. For example, ARRAY(MATCH(MIN({0,1,2,3}),{0,1,2,3},0). Would using such a UDF be no faster than array entering a formula ? - Ronald K. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating an array | Excel Programming | |||
creating an array | Excel Worksheet Functions | |||
creating an array | Excel Programming | |||
Creating and using an array | Excel Programming | |||
Creating an array | Excel Programming |