Faster? Subtotal or Aggregate

[patriciaanne]

Hi
Has anyone noticed if AGGREGATE() processes data faster than SUBTOTAL() if you have a lot of data you are calculating?
Thanks.
Patriciaanne

 

[shg]

In a simple test, Aggregate is about 1.4 times faster:

	H​	I​	N​	O​
1​	Range​	Formula​	Time/Calc​

[td="bgcolor:#F3F3F3"]

Rel Speed​

[/td]
[tr][td="bgcolor:#C0C0C0"]

2​

[/td][td]C1:C1000[/td][td] =AGGREGATE(9, 1, A1:A1000)[/td][td="bgcolor:#E5E5E5"]

0.000 020 416​

[/td][td="bgcolor:#E5E5E5"]

1.0​

[/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

3​

[/td][td]E1:E1000[/td][td] =SUBTOTAL(9, A1:A1000)[/td][td="bgcolor:#E5E5E5"]

0.000 015 121​

[/td][td="bgcolor:#E5E5E5"]

1.4​

[/td][/tr]

 

[shg]

The data is correct, but the statement is wrong; SUBTOTAL is faster.