Prev: Delete rows that don't contain...
Next: Data collection in Excel2003
From: Peter on 19 May 2010 07:26
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?
From: MimiS on 19 May 2010 07:36
You could set up a column next to your figures and use =rank.
From: Pritesh on 19 May 2010 07:45
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.
From: Jacob Skaria on 19 May 2010 08:36
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?
 | 
Pages: 1
Prev: Delete rows that don't contain...
Next: Data collection in Excel2003