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