This will divide the last cell in column D with a value in it by the cell
immediately above it,
=LOOKUP(2,1/(Sheet1!D1:D1000),Sheet1!D1:D1000)/(LOOKUP(2,1/(Sheet1!D1:D1000),Sheet1!D1:D1000)-1)
Regards,
Alan.
"Jean" wrote in message
...
I have a formula that looks like this:
=('Unit Values'!D$79/'Unit Values'!D$78)-1
The D$79 is referencing the last row of the 'Unit Values' sheet. Every
month I have to add another row of information in the 'Unit Values'
spreadsheet. This means that I have to edit all my formulas to read D$80.
The following month, I have to edit the formula to read D$81. This is
always
referencing the last row of data. There are no blank cells in column D.
Is
there a function that I could add to the above formula that will always
reference the last cell in that column? Thanks!