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
|