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),""))) |
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),""))) |
All times are GMT +1. The time now is 02:17 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com