How do I find the minimum value greater than zero

  • Thread starter Thread starter Guest
  • Start date Start date
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.
 
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 **
 
Back
Top