MIN IF >0

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to find the Min value of a range that is greater than 0.

Min (A1:A5) but ingore zero values.

Bruce
 
One way ..

Try: =MIN(IF(A1:A5>0,A1:A5))
Array-enter the formula,
i.e. press CTRL+SHIFT+ENTER
instead of just pressing ENTER
 

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

Min excluding zero values, without an array fomrula 13
Return Min & Cell address 7
Cell reference in formula string displays abbreviated value 2
Count entries in the column translating to minutes. 5
random integer with sum constraint 8
Indirectly us a Named Range 3
Min function excluding zero 5
Excel Need Countifs Formula Help 0

Back
Top