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

R

RocketDude

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




--
 
D

Dave Peterson

You've got more replies at your other post.
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
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Find Min of a row, but only greater than zero? 5
count the number of rows with entries greater than zero 1
How to sum x cells that are greater than zero on the right? 3
Average non-consecutive cells excluding zero 8
vlookup and match first value greater than 4
Countif and values greater than zero for a named range 1
Min function excluding zero 5
Minimum Date Greater than Today() 6

Top