Thread: Select the last value from a list
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Stefi Stefi is offline
external usenet poster
  
Posts: 2,646
Default Select the last value from a list
=INDIRECT("A"&COUNT(A:A))

Regards,
Stefi


€žSteve€ť ezt Ă*rta:

Column A contains a list of numbers. This list will vary in length. Cell C1
needs a formula to display the last (but not necessary largest/smallest)
figure in this list.

Any help would be appreciated
Reply With QuoteReply With Quote