I have an excel sheet that maintains a cost amount for each day. Each day is posted on a new row. I would like to produce the calculation with the difference between the last row (newest amount) and the previous row and write the difference in a new column in the last row. I’m familiar with index and using the for each row, I’m just not sure how to get the previous row data and calculate it with the last row.
The excel formula would be =F16-F15