Second MAX

[vano]

Hi,
Just wanted to see if anyone knew if there is an excel function to fin
the second highest value in a series?

Thanks in advance,

Van

 

[Dave Peterson]

There's an =large() function:

=large(a1:a10,2)

(And an =small() function, too.)

 

[Trevor Shuttleworth]

Vano

=LARGE(C1:K1,2)

Regards

Trevor

 

[Frank Kabel]

Hi
=LARGE(range,2)