One less than Max

[art]

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

 

[Jacob Skaria]

You mean the second largest

=LARGE(A1:F1,2)

third largest
=LARGE(A1:F1,3)


If this post helps click Yes