If there are only positive values

=LARGE(A1:A10,COUNTIF(A1:A10,"0"))

if there can be negative values

=MIN(IF(A1:A10<0,A1:A10))

note that the latter formula MUST be entered with ctrl + shift & enter

Regards,

Peo Sjoblom

"Blade" wrote:

I'm trying to keep the =MIN from returning 0 as the minimum value. Is this
possible?