Replace: The result displayed in less than 2 seconds

with: The result displayed in less than 5 seconds

"Charabeuh" <

[email protected]> a écrit dans le message de groupe de

discussion :

[email protected]
- Show quoted text -

Charabeuh,

Thanks for the quick response.

The arrays would be created using the INDEX and OFFSET functions.

The OFFSET function is a volatile function meaning that many things

you do in Excel would cause each formula that contains an OFFSET

function to recalculate - even if you didn't change a formula that

contained an OFFSET function.

For a large spreadsheet, this is a problem.

As for array entered formulas, they are to be avoided for large

amounts of calculations, especially when using volatile functions.

I recently replaced most array entered formulas with standard

formulas in a large spreadsheet and managed to cut recalculation time

down from 2.5 hours to 90 seconds.

I appreciate your effort.

It would be nice if Microsoft came up with a function similar to

SUMPRODUCT that would multiply arrays and give an array as a result.

Exceluser