One way:

=LARGE(rng,2)

=SMALL(rng,2)

In article ,
Michael Rekas wrote:

Hi there

Th MAX & MIN functions return the largest & the smallest values in a
range.

Is there a way to get the 2nd largest and smallest values?

Any help appreciated.

Thanks

Michael