E
Eric
Does anyone have any suggestions on how to determine the values under
following conditions?
Under column A, there is a list of numbers.
Under column C, there is a list of numbers.
There is 145 in cell G1.
Starting to sum from C1 to bottom, if the sum from C1 to C9 < 145 in cell G1
and the sum from C1 to C10 >= 145 in cell G1, then return highest number from
A1 to A10 into cell D1.
For the next number
Starting to sum from C2 to bottom, if the sum from C2 to C9 < 145 in cell G1
and the sum from C2 to C10 >= 145 in cell G1, then return highest number from
A2 to A10 into cell D2.
Does anyone have any suggestions?
Thanks in advance for any suggestions
Eric
following conditions?
Under column A, there is a list of numbers.
Under column C, there is a list of numbers.
There is 145 in cell G1.
Starting to sum from C1 to bottom, if the sum from C1 to C9 < 145 in cell G1
and the sum from C1 to C10 >= 145 in cell G1, then return highest number from
A1 to A10 into cell D1.
For the next number
Starting to sum from C2 to bottom, if the sum from C2 to C9 < 145 in cell G1
and the sum from C2 to C10 >= 145 in cell G1, then return highest number from
A2 to A10 into cell D2.
Does anyone have any suggestions?
Thanks in advance for any suggestions
Eric