Try this array formula

=MIN(IF((MOD(ROW(D15:D537),18)=1)*(D15:D537<0)*(D 15:D537<""),D15:D537))

--
__________________________________
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),"")))