Min. Value is Needed
 

I am trying to determine the min value of a column using the MIN command.

The column has the following values:
2
34
6
0
0
1

I would the minium value greater then zero to be displayed in a cell. I
have been able to use the Max command to determine the mx number but and Min
command displays 0 or if I setup a negative number it will display that
value.

Any suggestions?

Min. Value is Needed
 

=MIN(IF(A1:A60,A1:A6))

Enter with Ctrl+Shift+Enter (an array formula). You will {} brackets
enclosing the formula if entered correctly.

HTH

"Val" wrote:

I am trying to determine the min value of a column using the MIN command.

The column has the following values:
2
34
6
0
0
1

I would the minium value greater then zero to be displayed in a cell. I
have been able to use the Max command to determine the mx number but and Min
command displays 0 or if I setup a negative number it will display that
value.

Any suggestions?

Min. Value is Needed
 

One way

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



--
Regards,

Peo Sjoblom



"Val" wrote in message
...
I am trying to determine the min value of a column using the MIN command.

The column has the following values:
2
34
6
0
0
1

I would the minium value greater then zero to be displayed in a cell. I
have been able to use the Max command to determine the mx number but and
Min
command displays 0 or if I setup a negative number it will display that
value.

Any suggestions?