retrieve last entry in column

[Darrell Shuman]

I have a column that shows hours on a machine each time it is worked on. How
can I retrieve the bottom entry for use in another cell?
Thanks for your help.

Darrell

 

[Ian P]

Darrell

Assuming you haven't got gaps in your data:

=INDEX(H:H,COUNTA(H:H))

Ian