You could use the DMIN function but your cells have to be next to each other.
Perhaps you can create on another part of the spreadsheet links to your
cells. Example in cell A1 have = D162, in cell A2 have = D181, in cell A2
have = D136. Then run the DMIN function off of cells A1, A2, A3, etc.

=DMIN(A1:A13,A1,B1:B2)

Where B1:B2 has your criteria (column heading in B1 and 0 in B2).

Hope this helps.

Bill Horton

"seedy3" wrote:

Earlier I posted a question about ignoring zero values, Well when I posted
that it helped, I had not fully tried the suggestion with zeros and zero
values. Well here is what I have in the cell that is giving me the problem.
=MIN(D162:D181,D136:D155,D110:D129,D84:D103,D58:D7 7,D32:D51,D6:D25) many of
these cells contain a 0 (Zero) value from another formula so I cannot just
leave them blank. I tried
=MIN(If(D162:D181,D136:D155,D110:D129,D84:D103,D58 :D77,D32:D51,D6:D250,D162:D181,D136:D155,D110:D12 9,D84:D103,D58:D77,D32:D51,D6:D25))
But that doesn't work either, any suggestions?

Thanks