How do I find the second highest value.

  • Thread starter Thread starter Peter
  • Start date Start date
P

Peter

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?
 
If you do not have duplicate values, "Large" formula will be useful.

Try it like; =Large(A:A,2)

The number at the end of it represents position of highest number you
desire, so for third-highest you can put formula as =Large(A:A,3).
 
If you have the highest number duplicated; then try

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