Array formula speed

bkb

New Member
Joined
Oct 19, 2006
Messages
12
I've heard that array formula are typically less efficient, i.e. slower, than regular formulas. Looking for a way to demonstrate this, would appreciate some ideas.

Thanks.
 

Some videos you may like

Excel Facts

Which Excel functions can ignore hidden rows?
The SUBTOTAL and AGGREGATE functions ignore hidden rows. AGGREGATE can also exclude error cells and more.

RalphA

Well-known Member
Joined
May 14, 2003
Messages
3,829
If you consider a "normal" formula, with a term such as A1, as compared to an "array" formula, that includes the term A1:A100, it would seem obvious that the array formula is going to have to compare 100 cells, vs 1 cell in the "normal" formula. Thus, the array formula will take much longer to execute than the "normal" formula.

How much longer an array formula takes would depend on too many factors to even guess at a number, starting with the number of cells in the array considered.
 

Watch MrExcel Video

Forum statistics

Threads
1,111,596
Messages
5,541,154
Members
410,543
Latest member
ExcelGlenn
Top