View Single Post
  #2   Report Post  
JulieD
 
Posts: n/a
Default

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?