Smallest positive value

  • Thread starter Thread starter danpt
  • Start date Start date
D

danpt

Can someone help me with a formula that will return the smallest positive
value in a given unsorted range?
Thanks
 
=if(countif(a1:a10,">"&0)=0,"no value",min(if(a1:a10>0,a1:a10)))

This is an array formula. Hit ctrl-shift-enter instead of enter. If you do it
correctly, excel will wrap curly brackets {} around your formula. (don't type
them yourself.)

Adjust the range to match--but you can only use the whole column in xl2007.
 
Hi, Dave
Great help again.
Many thanks

Dave Peterson said:
=if(countif(a1:a10,">"&0)=0,"no value",min(if(a1:a10>0,a1:a10)))

This is an array formula. Hit ctrl-shift-enter instead of enter. If you do it
correctly, excel will wrap curly brackets {} around your formula. (don't type
them yourself.)

Adjust the range to match--but you can only use the whole column in xl2007.
Click to expand...
 
Back
Top