T
Takeadoe
Good morning group.
Formula in Cell F1 =SLOPE(D1014,B10:B14)
Formula in Cell F2 =SLOPE(D2024,B20:B24)
Formula in Cell F3 =SLOPE(D3034,B30:B34)
Formula in Cell F88=....
Here's the problem. A simple copy formula down operation will not
work for filling in cells F4-F88. What I end up with is this:
Formula in cell F4=SLOPE(D3135,B31:B35)
It is incrementing by 1, rather than the 10 that I need it to
(SLOPE(D4044,B40:B44). I will need to do this several more times
(grab various numbers of years (10, 15) to generate slope estimates.
Thus if there is something that requires a bit of work on the front
end that will allow me to easily make changes to the number of years
being used in the calculations, I'm all for it.
Any help on this matter is very much appreciated.
Mike
Formula in Cell F1 =SLOPE(D1014,B10:B14)
Formula in Cell F2 =SLOPE(D2024,B20:B24)
Formula in Cell F3 =SLOPE(D3034,B30:B34)
Formula in Cell F88=....
Here's the problem. A simple copy formula down operation will not
work for filling in cells F4-F88. What I end up with is this:
Formula in cell F4=SLOPE(D3135,B31:B35)
It is incrementing by 1, rather than the 10 that I need it to
(SLOPE(D4044,B40:B44). I will need to do this several more times
(grab various numbers of years (10, 15) to generate slope estimates.
Thus if there is something that requires a bit of work on the front
end that will allow me to easily make changes to the number of years
being used in the calculations, I'm all for it.
Any help on this matter is very much appreciated.
Mike