Creating an ARRAY UDF

[kittronald]

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.