Hi
Please tell me workaround given my numbers are in ascending order and a need
a minimum.
I have to find the minimum value greater than a number in a row of numbers
placed in ascending order.
The MATCH function requires the numbers to be in descending order with last
parameter of Match set to -1.
Match_type Behavior
1 or omitted MATCH finds the largest value that is less than or equal to
lookup_value. The values in the lookup_array argument must be placed in
ascending order, for example: ...-2, -1, 0, 1, 2, ..., A-Z, FALSE, TRUE.
0 MATCH finds the first value that is exactly equal to lookup_value. The
values in the lookup_array argument can be in any order.
-1 MATCH finds the smallest value that is greater than or equal to
lookup_value. The values in the lookup_array argument must be placed in
descending order, for example: TRUE, FALSE, Z-A, ...2, 1, 0, -1, -2, ..., and
so on.

Try,

with your lookup value in A2

=MIN(IF(A1:H1=A2,A1:H1))

This is an array formula which must be entered by pressing CTRL+Shift+Enter
'and not just Enter. If you do it correctly then Excel will put curly brackets
'around the formula {}. You can't type these yourself. If you edit the formula
'you must enter it again with CTRL+Shift+Enter.

Mike

"rupert" wrote:

Hi
Please tell me workaround given my numbers are in ascending order and a need
a minimum.
I have to find the minimum value greater than a number in a row of numbers
placed in ascending order.
The MATCH function requires the numbers to be in descending order with last
parameter of Match set to -1.
Match_type Behavior
1 or omitted MATCH finds the largest value that is less than or equal to
lookup_value. The values in the lookup_array argument must be placed in
ascending order, for example: ...-2, -1, 0, 1, 2, ..., A-Z, FALSE, TRUE.
0 MATCH finds the first value that is exactly equal to lookup_value. The
values in the lookup_array argument can be in any order.
-1 MATCH finds the smallest value that is greater than or equal to
lookup_value. The values in the lookup_array argument must be placed in
descending order, for example: TRUE, FALSE, Z-A, ...2, 1, 0, -1, -2, ..., and
so on.