return next higher value from unsorted array

[pkh]

Hi,

I have a matrix of time values which are not sorted. I need a formula to return the next higher value than a specified value from the matrix. For example, from the times in the column below, I want to know what is the next train in station X after the 04:31:29 train. I should get the answer 05:34:34 (The zero values means train B, F and G does not stop at StnX).

	Stn X
A	05:34:34
B	00:00:00
C	11:20:03
D	04:31:29
E	15:49:34
F	00:00:00
G	00:00:00

<tbody>
</tbody>

I have tried using the index match formula, using -1 as the match type but i get the same value 04:31:29 and not next higher value. Any help much appreciated.

Pankaj

 

[Asala42]

How about something like:

=LARGE($A$1:$A$7,RANK(A4,$A$1:$A$7)-1)

 

[pkh]

Asala42, that worked perfectly. Thanks a lot.

Pankaj