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.