Find Min of a row, but only greater than zero?

[RocketDude]

Hi,

Does anyone know how to find the minimum of a row of numbers, but only for
numbers greater than zero? I have over three hundred rows I need to perform
this same function on, so naming the row is out of the question.

For example, if my row is:

0 0 0 1 2 3 5 0 0.5

I want to find "0.5".

TIA

 

[Bob Phillips]

=MIN(IF(A2:M2<>),A2:M2)

which is an array formula, so commit with Ctrl-Shift-Enter

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Dave Peterson]

Another way...

=IF(COUNTIF(A1:I1,">"&0)=0,"No Positive numbers",MIN(IF(A1:I1>0,A1:I1)))

This is an array formula. Hit ctrl-shift-enter instead of enter. If you do it
correctly, excel will wrap curly brackets {} around your formula. (don't type
them yourself.)

 

[Sandy Mann]

Bob,

=MIN(IF(A2:M2<>),A2:M2)

I can't get that formula to work for me but

=MIN(IF(A2:M2<>0,A2:M2))

array entered does. Is it my 97 version of XL?

--
Regards

Sandy
(e-mail address removed)
Replace@mailinator with @tiscali.co.uk

=MIN(IF(A2:M2<>),A2:M2)

which is an array formula, so commit with Ctrl-Shift-Enter

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Bob Phillips]

No Sandy, it is a typo by me.

--

HTH

RP
(remove nothere from the email address if mailing direct)

Bob,

=MIN(IF(A2:M2<>),A2:M2)

I can't get that formula to work for me but

=MIN(IF(A2:M2<>0,A2:M2))

array entered does. Is it my 97 version of XL?

--
Regards

Sandy
(e-mail address removed)
Replace@mailinator with @tiscali.co.uk

 

[RocketDude]

Thank you to everyone who posted a solution! You saved me.

Regards,