Help with Min function

Hi Guy's
Can anyone help?
I'm trying to return the minimum value in a row of numbers but want to ignore all zero values that may be contained in the row & only return a positive or negative number.

Thanks in advance.

Lloydee.

Hi,

Following formula will do the job ...
as an array formula (Control Shift Enter instead of regular enter)

=MIN(IF(A1:A100>0,A1:A100,""))


HTH
Cheers
Carim

Thanks guy's.
That worked a treat.

Lloydee.