showing values in increasing order

[KSch]

I am using
=INDEX($A$1:$R$1,MATCH(MIN(A7:R7),A7:R7,0)) to find the minumum number in the array. How do I display the value one position greater? I need to order the numbers and titles in increasing order.

also any way to ignore the 0 vakues in the cell in the MIN function?

 

[Gerald Higgins]

To get the next higher value, try this

=INDEX($A$1:$R$1,MATCH(SMALL(A7:R7,2),A7:R7,0))

Note that this deals with 0 values the same way as your original formula.
Also, watch out for unexpected results if you have two or more identical values that are both one above the minimum.
Also, you could use this formula to identify the minimum value, by replacing the 2 with a 1. This might simplify your application a little.

 

[Gerald Higgins]

This is cumbersome, but it works to ignore the min value if it is zero, and looks for the next minimum value.
If there are 2 zero values, this won't work.
There are probably better ways of doing this.

=IF(SMALL(A7:R7,1)=0,INDEX($A$1:$R$1,
MATCH(SMALL(A7:R7,2),A7:R7,0)),INDEX($A$1:$R$1,
MATCH(SMALL(A7:R7,1),A7:R7,0)))