Dynamic Array Formula

[dw7]

I have an array formula on a column. However, the column's data might change at times, and the dynamic formula doesn't seem to update unless I manually click command+enter on it again.

Any way to get it to update automatically like normal formulas in excel?

 

[Aladin Akyurek]

I have an array formula on a column. However, the column's data might change at times, and the dynamic formula doesn't seem to update unless I manually click command+enter on it again.

Any way to get it to update automatically like normal formulas in excel?

Check whether Tools|Options|Calculation is set to automatic.

If that's the case, try to post the formula here in your reply.

 

[dw7]

That worked perfectly, thanks!