minimum value of a range with an "if" condition

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Carmen - 18 Jan 2007 21:52 GMT

I have a row of numbers that range from 0 to 100. I want to find the minimum number that is also greater than 10, sort of like

=min(A1:A50,">10") which I know will not work. Any help? Thanks in advance.

Signature

CARMEN HOVENDICK

Reply to this Message

JE McGimpsey - 18 Jan 2007 21:58 GMT

One way (array-entered: CTRL-SHIFT-ENTER or CMD-RETURN):

=MIN(IF(A1:A50<=10,"",A1:A50))

> I have a row of numbers that range from 0 to 100. I want to find the minimum
> number that is also greater than 10, sort of like
>
> =min(A1:A50,">10") which I know will not work. Any help? Thanks in advance.

Reply to this Message

RagDyer - 18 Jan 2007 23:28 GMT

Another way ... Non-array approach:

=SMALL(A1:A50,1+COUNTIF(A1:A50,"<=10"))

Signature

HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

> One way (array-entered: CTRL-SHIFT-ENTER or CMD-RETURN):
>
[quoted text clipped - 6 lines]
>> =min(A1:A50,">10") which I know will not work. Any help? Thanks in
>> advance.

Reply to this Message

Carmen - 19 Jan 2007 19:51 GMT

Rag, JE, thanks

Signature

CARMEN HOVENDICK

> Another way ... Non-array approach:
>
[quoted text clipped - 10 lines]
>>> =min(A1:A50,">10") which I know will not work. Any help? Thanks in
>>> advance.

Reply to this Message