If there are no negative values

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

if there are negative values

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

the latter needs to be entered with ctrl + shift & enter

Regards,

Peo Sjoblom

"Douglas McDonald" wrote:

I need to find the min in a column but don't want (0's) zeros