Hi, I have a chart of numbers and i need the difference inbetween 2 cells (shown here on the left and right) to be divided up equally between the amount of cells inbetween the cells. The amount of cells in the centre here is two but the amount will vary.
Please see below where i have manually worked one out to give you an example.
----A ------B------C-------D
1 13.78--14.52--15.46---16.30
2 15.24------------------ 21.17
3 22.74------------------ 29.09
4 26.84------------------ 35.42
5 32.10------------------ 40.71
6 37.02------------------ 49.84
7 44.60------------------ 57.58
8 49.58------------------ 62.05
There are a lot of numbers to the right an left of these cells, so I cant use those cells in the formula unless its way over, about 40 columns to the right.
Could this be made simpler? I know i'd have to do a formula for every column but would something like this work, however I'd need help with translating my suggestion into a formula.
How would I write this formula correctly? =d1-a1 divided by 3 plus a1. This would be based on 2 blank columns in the centre as above, this is basically how I worked it out on the calculator. If I did this then wrote a new formula for the remaining column??!
Please see below where i have manually worked one out to give you an example.
----A ------B------C-------D
1 13.78--14.52--15.46---16.30
2 15.24------------------ 21.17
3 22.74------------------ 29.09
4 26.84------------------ 35.42
5 32.10------------------ 40.71
6 37.02------------------ 49.84
7 44.60------------------ 57.58
8 49.58------------------ 62.05
There are a lot of numbers to the right an left of these cells, so I cant use those cells in the formula unless its way over, about 40 columns to the right.
Could this be made simpler? I know i'd have to do a formula for every column but would something like this work, however I'd need help with translating my suggestion into a formula.
How would I write this formula correctly? =d1-a1 divided by 3 plus a1. This would be based on 2 blank columns in the centre as above, this is basically how I worked it out on the calculator. If I did this then wrote a new formula for the remaining column??!
