CSE formulas?

[Guest]

When I update a range than a CSE formula is referencing, Excel takes longer
than usual to calculate. Is this normal or just particular to my pc?

 

[Chip Pearson]

Array formulas take longer to calculate because they calculate as
many times as there are items in the array.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

 

[Guest]

Thanks, Chip.

I discovered another reason. The ranges I set up to be referenced were
entire columns (i.e. from rows 1-65536). I shortened the range to row 2500
and the calculation time was much faster.

Thanks again.

Gregory