Excel (non zero min value)
 

I have column of totals calulated by using the sum of row elements. I want
to find the non zero minimum value. I tried to SORT but that didn't work.
Help menu suggested DMIN, but this also did not work for me. I am sure there
must be an easy answer. Please help.
--
Megan (wanting a quiet life)

Excel (non zero min value)
 

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

--
Gary''s Student - gsnu200735


"Megan" wrote:

I have column of totals calulated by using the sum of row elements. I want
to find the non zero minimum value. I tried to SORT but that didn't work.
Help menu suggested DMIN, but this also did not work for me. I am sure there
must be an easy answer. Please help.
--
Megan (wanting a quiet life)

Excel (non zero min value)
 

Another way would be to change your summation formulas as follows.

=IF(YourSumFormula=0,"0",YourSumFormula)

Then the regular =MIN(C1:c10) would work to give you the minimum NUMBER of
what is left.

hth
Vaya con Dios,
Chuck, CABGx3

"Megan" wrote:

I have column of totals calulated by using the sum of row elements. I want
to find the non zero minimum value. I tried to SORT but that didn't work.
Help menu suggested DMIN, but this also did not work for me. I am sure there
must be an easy answer. Please help.
--
Megan (wanting a quiet life)

Excel (non zero min value)
 

if all values are zero or positive another method would be
=small(range,countif(range,0)+1))

"Megan" wrote:

I have column of totals calulated by using the sum of row elements. I want
to find the non zero minimum value. I tried to SORT but that didn't work.
Help menu suggested DMIN, but this also did not work for me. I am sure there
must be an easy answer. Please help.
--
Megan (wanting a quiet life)