AGGREGATE vs LARGE. Efficiency comparison

Hello!
Tested above functions
put everything on AGGREGATE and lost
AGGREGATE AGGREGATE whole column LARGE LARGE whole column
T 0,258 sec T 19,446 sec T 0,221 sec T 18,096 sec
One advantage is no need for CTRL+SHIFT+ENTER

Hi Tim,

The general topic for this is called Volatile Functions:
http://www.decisionmodels.com/calcsecretsi.htm
I think the above was written before the Aggregate Function showed up in Excel.

https://www.vertex42.com/blog/excel-...functions.html

Thanks for the info.