ExcelBanter - How do I find the second highest value.

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How do I find the second highest value. (https://www.excelbanter.com/excel-discussion-misc-queries/264092-how-do-i-find-second-highest-value.html)

Peter

How do I find the second highest value.

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?

MimiS

How do I find the second highest value.

You could set up a column next to your figures and use =rank.

Pritesh[_2_]

How do I find the second highest value.

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).

--
Regards,
Pritesh

"MimiS" wrote:

You could set up a column next to your figures and use =rank.

Jacob Skaria

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?

bala_vb

Quote:

Originally Posted by Peter (Post 954597)

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?

you can use either rank or large function, it depends up on whether duplicate values exist or not.

all the best

All times are GMT +1. The time now is 10:43 PM.