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:

[Table="width:, class:grid"][tr][td="bgcolor:#C0C0C0"][/td][td="bgcolor:#C0C0C0"]

H​

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

I​

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

N​

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

O​

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

1​

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

Range​

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

Formula​

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

Time/Calc​

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

Rel Speed​

[/td][/tr]
[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]
[/table]

 

[shg]

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