Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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) |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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) |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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) |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|