formula to choose the minimum number but>5 in group numbers 1 - 1.

[Guest]

I have this group of numbers: 1, 2, 3, 4, 5, 6, 7, 8, 9, 10.
I want to know the excel's formula to choose the minimum number in the group
of numbers > 5 .

Please help me.

Many thanks.

Khanh.

 

[duane]

=MIN(IF(A4:A13>5,A4:A13))

entered as an array (control+shift+enter)

assuming the range of data is a4:a1

 

[Myrna Larson]

An array formula, entered with CTRL+SHIFT+ENTER:

=MIN(IF(A1:A10>5,A1:A10))

 

[JWolf]

=MIN(IF(A1:A10>5,1,9E+99)*(A1:A10))

This is an array formula enter with: ctrl+enter

Only works with positive numbers.

 

[Myrna Larson]

You don't need to multiply here. If you leave the 2nd argument of the IF
formula blank, it will return FALSE. MIN ignores FALSE. That eliminates any
constraint re working only with positive numbers (though that point is not
relevant here as the OP wants numbers > 5).