=MIN() Function
 

I Have values in a range A1:C5

which contains for eg. 1, 5, 200, 0, 18, 15 etc etc

I want to Find A minimun from this range but it should ignore Zero. and give
me a min other then Zero

Eg. for the above range =Min(A1:C5) gives = 0
I want it to give me 1 not Zero

Any help please
Claude

=MIN() Function
 

Trythis

=MIN(IF(A1:A10=0,"",A1:A10))


Mike

"claude jerry" wrote:

I Have values in a range A1:C5

which contains for eg. 1, 5, 200, 0, 18, 15 etc etc

I want to Find A minimun from this range but it should ignore Zero. and give
me a min other then Zero

Eg. for the above range =Min(A1:C5) gives = 0
I want it to give me 1 not Zero

Any help please
Claude

=MIN() Function
 

try the following array formula (entered with CTRL+SHIFT+ENTER):
=MIN(IF(A1:C50,A1:C5))

--
Gary''s Student - gsnu200737


"claude jerry" wrote:

I Have values in a range A1:C5

which contains for eg. 1, 5, 200, 0, 18, 15 etc etc

I want to Find A minimun from this range but it should ignore Zero. and give
me a min other then Zero

Eg. for the above range =Min(A1:C5) gives = 0
I want it to give me 1 not Zero

Any help please
Claude

=MIN() Function
 

Claude

I got the range incorrect so
=MIN(IF(A1:C10=0,"",A1:C10))

It's now an array so Ctrl+Shift+enter
Note this formula ignores zero and allows negative numbers.

Mike

"claude jerry" wrote:

I Have values in a range A1:C5

which contains for eg. 1, 5, 200, 0, 18, 15 etc etc

I want to Find A minimun from this range but it should ignore Zero. and give
me a min other then Zero

Eg. for the above range =Min(A1:C5) gives = 0
I want it to give me 1 not Zero

Any help please
Claude

=MIN() Function
 

Thanks . its working Perfect

"Mike H" wrote:

Claude

I got the range incorrect so
=MIN(IF(A1:C10=0,"",A1:C10))

It's now an array so Ctrl+Shift+enter
Note this formula ignores zero and allows negative numbers.

Mike

"claude jerry" wrote:

I Have values in a range A1:C5

which contains for eg. 1, 5, 200, 0, 18, 15 etc etc

I want to Find A minimun from this range but it should ignore Zero. and give
me a min other then Zero

Eg. for the above range =Min(A1:C5) gives = 0
I want it to give me 1 not Zero

Any help please
Claude