Hello,
I'm attempting to put a dynamic calculation within an workbook that will calculate the year to date change (in percentage or nominal, either or), in the data set that changes as new data is appended to the end of the column. I have found some formulas that will return the value of the last cell but thus far I've been unable to get them to work, and I am unsure how I would need to nest them in a function to produce the calculation wanting.
So, for an example:
In C2, I would like to return the % change from the last row of data, say B137, and B125; ((B137-B125)/B125). But, each month we will append a new row of data to the table and would like it to update accordingly (B137 -> B138 and B125 -> B126). Is this a type of function that can be done using non-VBA tools? Any suggestions are much appreciated.
This is being done in Excel 2013.
I'm attempting to put a dynamic calculation within an workbook that will calculate the year to date change (in percentage or nominal, either or), in the data set that changes as new data is appended to the end of the column. I have found some formulas that will return the value of the last cell but thus far I've been unable to get them to work, and I am unsure how I would need to nest them in a function to produce the calculation wanting.
So, for an example:
In C2, I would like to return the % change from the last row of data, say B137, and B125; ((B137-B125)/B125). But, each month we will append a new row of data to the table and would like it to update accordingly (B137 -> B138 and B125 -> B126). Is this a type of function that can be done using non-VBA tools? Any suggestions are much appreciated.
This is being done in Excel 2013.
