| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
second minimum value
Hi,
I have a formula....=INDEX(A10:A20,MATCH(MIN B10:B20),B10:B20,0)) which returns the name in column A that corresponds to the minimum number in B10:B20. I would like a formula to also give me the second least valued number in B10:B20. And the third, fourth and fifth. Also, what will happen if there are two numbers that are minimum and equal to each other? Thank you, Ken |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Finding minimum value across selected rows of an array | Excel Worksheet Functions | |||
| Hiding Values Below Z Axis Minimum Value on Axis Charts | Charts and Charting in Excel | |||
| How do I get "minimum value" in a range to NOT return zero? | Excel Worksheet Functions | |||
| lookup - return minimum value | Excel Worksheet Functions | |||
| Sum minimum values in a pivot table | Excel Worksheet Functions | |||
Threaded Mode
