Thread: find last value in list
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Carim Carim is offline
external usenet poster
  
Posts: 510
Default find last value in list
With an array function :

=INDEX(A1:A10,MAX((A1:A100)*(ROW(A1:A10)))-ROW(A1:A10)+1)

Control+Shift+Enter instead of Enter to accept formula

HTH
Cheers
Carim

Reply With QuoteReply With Quote