One less than Max

  • Thread starter Thread starter art
  • Start date Start date
A

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
 
You mean the second largest

=LARGE(A1:F1,2)

third largest
=LARGE(A1:F1,3)


If this post helps click Yes
 
Back
Top