One less than Max
 

Hello all:

I would like to know, which formula do I use to get one less than the max in
a list.
For E.G. if I have in A1:F1 a list of numbers. How can I get one less than
the max and two less than the max and so on.

Any help is appreciated.

Thanks.

Art

One less than Max
 

You mean the second largest

=LARGE(A1:F1,2)

third largest
=LARGE(A1:F1,3)


If this post helps click Yes
---------------
Jacob Skaria


"art" wrote:

Hello all:

I would like to know, which formula do I use to get one less than the max in
a list.
For E.G. if I have in A1:F1 a list of numbers. How can I get one less than
the max and two less than the max and so on.

Any help is appreciated.

Thanks.

Art