ExcelBanter - retrieve last entry in column

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - retrieve last entry in column (https://www.excelbanter.com/excel-worksheet-functions/92430-retrieve-last-entry-column.html)

Darrell Shuman

retrieve last entry in column

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

retrieve last entry in column

Darrell

Assuming you haven't got gaps in your data:

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

Ian

"Darrell Shuman" wrote:

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

All times are GMT +1. The time now is 09:22 AM.