Thread
:
How do I get "minimum value" in a range to NOT return zero?
View Single Post
#
2
JulieD
Posts: n/a
Hi Blade
try
=SMALL(C1:C10,COUNTIF(C1:C10,0)+1)
where C1:C10 is the range you're looking for the minimum in.
Cheers
JulieD
"Blade" wrote in message
...
I'm trying to keep the =MIN from returning 0 as the minimum value. Is this
possible?
Reply With Quote