The current formula in my spreadsheet is the following:
=((Z$39-Z$38)/Z$38*100)
The Z column contains numerical data.
Each time I update the spreadsheet I add a new row to column Z and have to update the above formula with the new cell. For example, next month I'll have to update it to:
=((Z$40-Z$39)/Z$39*100)
How do I change this formula to automatically find the last cell in column Z AND the second from last cell in Google Spreadsheets? Thanks!