Thread
:
Minimum value in a range > 0
View Single Post
#
3
Don Guillett
Posts: n/a
non array enter with enter only
=SMALL(C1:C10,COUNTIF(C1:C10,0)+1)
array - enter with control+shift+enter
=MIN(IF(C1:C100,C1:C10))
--
Don Guillett
SalesAid Software
"Barbara" wrote in message
...
I have a range of cells where I would like to find the minimum value
greater
than 0.
For example:
18
12
0
16
19
I need a formula to look at the entire range and result in the lowest
value,
in this case 12.
Thanks for the help.
Reply With Quote