MIN or DMIN ?

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

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