Thread: Last Cell in a Column Value
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Terry Muskoff Terry Muskoff is offline
external usenet poster
  
Posts: 1
Default Last Cell in a Column Value
Assuming that there are no gaps in the data...

=INDEX(A1:A5000,COUNT(A1:A5000),1)

Start at the first cell if not A1, likewise adjust A5000 to somewhat
past the last cell with data.
Reply With QuoteReply With Quote