Continue the calculation but stops at 99 *

[learning]

If you could instruct me on how to do what I want to accomplish, I believe I can do it. I have the bear bones basics down. So to sum up, any suggestions would be greatly appreciated.

[DocAElstein]

Hi learning
Welcome to the Forum.
On the face of it it seems very simple.
But it is not clear to me exactly what you are asking.



Also I appears to stop at 94 in the uploaded worksheet?


I upload a quick attempt at what i think you might be asking:
All I did was the following:
_ I inserted a column at F. ( Initially I was thinking of copying all 4 columns, but then I noticed that you wanted to compress to 3 columns. So the extra column was not needed. ( By inserting the column all formulas were automatically adjusted by Excel) )
I changed the formula in F2 to be absoulte ( adding the $'s ), then copied it to D4
Then I copied formula G2 and I2 to E45 and F4, and adjusted so that they did the same as before, but using D4 instead of F2
Then I copied the second data row and adjusted where necersary so they worked on the new data columns.
Then simply selected the second row, moved the mouse to the bottom right of the selection over the small square point until a + appeared. Then you hold the left mouse down and just drag the formulas down

Alan

[learning]

Thank you DocAElstein for helping me. As you can see in the picture I changed the ratio to 3 and the limit to 600. In the picture you see that it's confusing because columns G H and I are still there which are not needed because they are now C D and E. and then you see that the calculations stop at 520 in D103 and continue with 1's and 4's. I need it to continue calculating to 600 or to whatever number I put as the limit in B3chart1returnpic.jpg