View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ian P
 
Posts: n/a
Default 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