View Single Post
  #1   Report Post  
Ken
 
Posts: n/a
Default 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