View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bumblebee Bumblebee is offline
external usenet poster
 
Posts: 18
Default Is there an excel funtion that retreives the last cell of a list

Is there an excel funtion that retreives the last cell of a list that
contains data. And then one that will find the next to the last, etc. The
list, or series kees getting longer but I always want to link a cell in a
table to the last data of the list, at the end of the list. With the offset
function it can be done but I was wondering if there was a better function.

version: excel 2003