Hi,

I wanted to know how can i make an array formula that uses the last written cell to do a calculation.

Every day I upload new information in a table. And the last column of this table makes the diference between the last updated data and the year-end figures.

Let's say:
Monday: i put the values on cell A1 this means than the last cell (AB1) will be doing A1-AB1
Tuesday: i put the values on cell B1 this means than the last cell (AB1) will be doing B1-AB1
Wednesday: C1 - AB1
Thursday: D1 - AB1
and so on...

Normally i do this manually but i guess there is probably an automatic way to do this.

Can someone help me?

Thanks in advance.