Let me see if I can explain this. I have these
range of cells: (D7,D37,D67,D97,D127,D157,D187,D217,D247,D277), and when I
use the MIN() function =MIN(D7,D37,D67,D97,D127,D157,D187,D217,D247,D277) I
get 0 because the values in the range are (1,5,0,5,0,0,1,3,1,2). But I want
my result to be 1 because 1 is the next higher number to zero in the range.
In the same instance, if the values in the range are
(14,14,0,14,0,0,14,0,14,14) I want my result to be 14, because 14 is the next
higher number to zero in the range. This is want I am trying to achieve.