Try


COL A
1
2
3
4
55
66
55
35 =INDIRECT("D"&(MAX(COUNT(D:D),1)))
55


"Jean" wrote:

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!