Thread: How do I find the second highest value.
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Jacob Skaria Jacob Skaria is offline
external usenet poster
  
Posts: 8,520
Default How do I find the second highest value.
If you have the highest number duplicated; then try

=LARGE(A:A,COUNTIF(A:A,MAX(A:A))+1)

--
Jacob (MVP - Excel)


"Peter" wrote:

I have a set of numbers where I need to find the highest value and the next
highest value. I can use MAX to find the highest, but how do I find the next
one?
Reply With QuoteReply With Quote