If you work with chronological lists or daily updates, you might also track the last item in a constantly changing list of values. Fortunately, you can combine Excel’s INDEX() and COUNTA() functions to return the last value in a list by using the following expression:
=INDEX(column, COUNTA(column), 1)
For instance, to return the last value in column A, you’d use the expression
=INDEX(A:A, COUNTA(A:A), 1)
As you update the list, the formula automatically compensates.
The one thing this formula can’t handle is an empty cell. For instance, the formula for column B (cell G3) returns 0 when it encounters the empty cell (at cell C9).
However, if you enter 0, instead of leaving the cell blank, the formula returns the correct value, 0.073.