Gord Dibben <gorddibbATshawDOTca wrote...
Or if you know what the last row will be, this is easier to type.

=INDEX($A:$A,5-(ROW(A1)-1))
....

Picky: this only works for ranges that start in row 1. Gary's formula
works for ranges starting in any row.

If the last row is known, and the first row is known, then the whole
range should be known. If so, here's a simplification that works for
ranges starting in any row. For example, if the range were C5:C24,

C5:
=INDEX($C$5:$C$24,ROWS($C5:$C$24))

and fill down.