Finding Minimum value

[Ruan]

Hello,

I know the formula for finding the minimum value in a range is
=MIN(G7:G31)

But how do you find the minimum value and ignore all the 0 values?

Thanks
Ruan

 

[Ken Wright]

Assuming all data is positive and you just want to exclude 0s, then

=MIN(IF(A1:A100>0,A1:A100)) array entered using CTRL+SHIFT+ENTER

 

[Guest]

Ken is right. the only difference I would use if you do want to unclude negative values is to change the argument to =MIN(IF(or(A1:A100>0,a1:a100<0),A1:A100)) This will let you select the negatives as well

 

[Ken Wright]

With negatives in there but excl 0s

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

array entered

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission
----------------------------------------------------------------------------

Ken is right. the only difference I would use if you do want to unclude

negative values is to change the argument to
=MIN(IF(or(A1:A100>0,a1:a100<0),A1:A100)) This will let you select the
negatives as well

 

[Ruan]

Thanks Bruce and Ken. Ken's formula is what I needed, as I am looking for
the minimum percentage above 0 in a range.

Ruan