Problem in Min()

[manojk71273]

Hi all

A B C D E
0 1 25 35 min(a1:D1)

The answer is 0 - but I want reasult which is not zero

Please help

Manoj

 

[Richard Schollar]

Try:

=MIN(IF(A1:D1<>0,A1:D1))

Confirmed with Ctrl+Shift+Enter

 

[barry houdini]

Another way which just requires enter...

=LARGE(A1:D1,COUNTIF(A1:D1,">0"))

 

[manojk71273]

Thanks all

my problem is solved

Manoj