DMAX Array Index Sumproduct
0.0240969 0.0240885 0.0243997 0.0243215
0.0127678 0.0128463 0.0129556 0.0126991
0.0128880 0.0128690 0.0126720 0.0128310
0.0127262 0.0127622 0.0129514 0.0129377
0.0239782 0.0129301 0.0126226 0.0243023
0.0127907 0.0244173 0.0242073 0.0127064
0.0126882 0.0126583 0.0127625 0.0127427
0.0126734 0.0129637 0.0127756 0.0129603
0.0241332 0.0126843 0.0127209 0.0243031
0.0127002 0.0127251 0.0127625 0.0126938

0.0161443 0.0150945 0.0150830 0.0162498 Average

0.0241332 0.0244173 0.0243997 0.0243215 Max
0.0126734 0.0126583 0.0126226 0.0126938 Min
0.0114598 0.0117590 0.0117772 0.0116277 Range

testing *initial* calculations
I'm sorry - I should have been specific about what was being tested...

"T. Valko" wrote:

Those look like recalculaion times. I get similar results when I test the
recalculation time.

I tested the *initial* calculation times.

--
Biff
Microsoft Excel MVP