Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need help with formulas
This is my situation: I have a buch of cells, not consistent, that have
values and I am trying to get the minimum value, not zero, in those bunch of cells. for example this formula: =MIN(D15,D33,D51,D69,D87,D105,D123,D141,D159,D177, D195,D213,D231,D249,D267,D285,D303,D321,D339,D357, D375,D393,D411,D429,D447,D465,D483,D501,D519,D537) If the above formula has zero in a few of the ranges, say D51, D141, D213, D339, D411, D465 and D501. The above formula will result in a zero but I don't want the zero value. I want the next minumum value that is not zero. Is there a fuction that I can use for that? And also if there is a way to modify and use the formula below to obtain the same result, that would be appreciated too. Thanks =IF(COUNTA(G307:CF307)=0,"",MIN(IF(G307:CF307<"", VALUE($G$306:$CF$306),""))) |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need help with formulas
See reply in .misc
-- __________________________________ HTH Bob "Ayo" wrote in message ... This is my situation: I have a buch of cells, not consistent, that have values and I am trying to get the minimum value, not zero, in those bunch of cells. for example this formula: =MIN(D15,D33,D51,D69,D87,D105,D123,D141,D159,D177, D195,D213,D231,D249,D267,D285,D303,D321,D339,D357, D375,D393,D411,D429,D447,D465,D483,D501,D519,D537) If the above formula has zero in a few of the ranges, say D51, D141, D213, D339, D411, D465 and D501. The above formula will result in a zero but I don't want the zero value. I want the next minumum value that is not zero. Is there a fuction that I can use for that? And also if there is a way to modify and use the formula below to obtain the same result, that would be appreciated too. Thanks =IF(COUNTA(G307:CF307)=0,"",MIN(IF(G307:CF307<"", VALUE($G$306:$CF$306),""))) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
E2007 formulas display as formulas, not results | Excel Worksheet Functions | |||
Counting # of Formulas in a column with formulas and entered data | Excel Worksheet Functions | |||
CELLS NOT CALC FORMULAS - VALUES STAY SME FORMULAS CORRECT?? HELP | Excel Worksheet Functions | |||
Formulas not evaluated, Formulas treated as strings | Excel Discussion (Misc queries) | |||
AdvancedFilter on cells with formulas, returning values and not formulas | Excel Programming |