Hello Opus,

This works, assuming your data is in cells A1 to G1.

=MIN(IF($A$1:$G$1=0,MAX($A$1:$G$1),$A$1:$G$1))

You have to submit it as an array formula (type the formula then press
Ctrl+Shift+Enter).

What it does is look at all the values individually, and any time it finds a
zero it thinks about it as the biggest number in the range instead (thereby
excluding it from the MIN).
--
If you found this post helpful, please click "Yes".
Allllen


"Opus" wrote:

I need to find the minimum non-zero number in a range of cells that contains
some zeroes. So that I can divide by the minimum number. Any ideas?

If I just use the MIN function, it returns a value of 0, then when my
formula divides by that I get the divide by zero error.