Thread: How do I get excel to choose the second to last # in a series?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Ron Coderre Ron Coderre is offline
external usenet poster
  
Posts: 2,118
Default How do I get excel to choose the second to last # in a series?
This formula returns the 2nd largest number from A1:A100
=LARGE(A1:A100,2)

Is that something you can work with?

Regards,

Ron
Microsoft MVP (Excel)


"coolerthancool" wrote in message
...



Reply With QuoteReply With Quote