Find the MAX number in range, then find...
For the nth largest value:
LARGE(range,n)
where n = 1, 2, 3, 4 etc.
LARGE(range,1) is the same as MAX(range)
--
Biff
Microsoft Excel MVP
"pgarcia" wrote in message
...
Hello all,
I'm lookin to find the MAX number in range, which I'm able to do. But I
would like the find the next low number from the MAX number. I'm also
using
the INDEX-MATCH combo on this.
Background: I have list of 5 colums and I need to ge the top ten customer
info 1st by aging then by $ amount. So in my 1st top ten, it has the
cutomer
info by oldest day. The 2nd top ten is customer info by hights $ amount.
Thanks
|