Minimum Value Excluding Zero In Excel Range

[S M C]

Here's a way to find the minimum value in a range of cells, after excluding zero



Dim rng as range
Set rng = Range("SomeRangeWhichAlsoHasZeroesInIt")
dbl = Evaluate("MIN(IF(" & rng.Address & "=0,""""," & rng.Address & "))")

[Admin]

It could also be written as


dbl = Evaluate("MIN(IF(" & rng.Address & "<>0," & rng.Address & "))")

[Rasm]

Would that not exclude all negative numbers as well as zero?

can you use

<>0

[Admin]

Would that not exclude all negative numbers as well as zero?

can you use

<>0

Thanks Rasm. I edited the formula.