finding minimum value excluding zero
The best way I can think of to do this would be to insert a "helper"
column next to the list of values, then write a formula like this one
=IF(a10,a1,"")
....and then copy/paste that formula for each value in the list. This
will return only the values that are greater than zero; you can then
use the MIN() function over that range to find the smallest non-zero
value.
Dave O
|