retrieve last entry in column

  • Thread starter Thread starter Darrell Shuman
  • Start date Start date
D

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
 
Darrell

Assuming you haven't got gaps in your data:

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

Ian
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA - retrieve data on last create named range from previous inserted named range 0
Help needed 0
Daily Time Sheets with Rounding 1
Go to cell below last entry in column and total 1
Can I find the last value in a column of cells? 4
formula for displaying only the last entry of a group of cells 2
Retrieve data based on 3 criteria 3
display last entry into a cell automatically 2

Back
Top