How do I find the minimum value greater than zero

G

Guest

I have generated a column of numbers using a function in each cell in the
column. How can I find the minumum value GREATER THAN ZERO in that column?
The MIN and MINA functions are finding zero values created by the functions,
but I need to know the lowest value greater than zero in the column. I'm
using Excel 2000.
 
P

Paul B

oldgrayelf, here is one way, =MIN(IF(A1:A10>0,A1:A10))
this is an array formula, hold down <ctrl>+<shift> while hitting <enter>.

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2000 & 2003
** remove news from my email address to reply by email **
 

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

count the number of rows with entries greater than zero 1
Find the last value <> 0 2
Identifying the # of cells containing data 3
Last cell in column greater than zero? 7
locate first value greater than 6
Minimum Date Greater than Today() 6
text if negative value 2
last value "greater than zero" in a range 3

Top