Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
find number within a range | Excel Worksheet Functions | |||
How to find the number of value within a range? | Excel Worksheet Functions | |||
How to find the number of value within a range? | Excel Discussion (Misc queries) | |||
Find a negative number in a range | Excel Worksheet Functions | |||
find the cell above any number in any range | Excel Worksheet Functions |