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

Hi and sorry for the cross-posting but I'm desperate,

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

--
Matthew




--

=SMALL(A2:F2,COUNTIF(A2:F2,"<=0")+1)

RocketDude wrote:
Hi and sorry for the cross-posting but I'm desperate,

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

You've got more replies at your other post.

RocketDude wrote:

Hi and sorry for the cross-posting but I'm desperate,

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

--
Matthew

--

--

Dave Peterson

Thank you.

Regards,

--
Matthew

"Aladin Akyurek" wrote in message
...
=SMALL(A2:F2,COUNTIF(A2:F2,"<=0")+1)

RocketDude wrote:
Hi and sorry for the cross-posting but I'm desperate,

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