jwalkerack
Board Regular
- Joined
- Jun 19, 2013
- Messages
- 81
Hi , i have some data that i am trying to extend
i have got to the stage where i can insert a new row between all of my data sets
i would now like to be able to fill in the average between the above and below cell.
So in the example below i have time and distance . In both columns i like to be able automatically fill in the average. Is this possible through a macro or formula to automatically do this? Thanks for reading and for your help .
Sorry just a last note , for example in the blank cell for A4 , i like it to calculate the average bewteen 30 and 50 so 30+50/2 = 40 . For the time it would be 40+10/2 = 25 . But i like to fill in the all the blank cells with data above and below
<tbody>
</tbody>
i have got to the stage where i can insert a new row between all of my data sets
i would now like to be able to fill in the average between the above and below cell.
So in the example below i have time and distance . In both columns i like to be able automatically fill in the average. Is this possible through a macro or formula to automatically do this? Thanks for reading and for your help .
Sorry just a last note , for example in the blank cell for A4 , i like it to calculate the average bewteen 30 and 50 so 30+50/2 = 40 . For the time it would be 40+10/2 = 25 . But i like to fill in the all the blank cells with data above and below
Time | Distance |
30 | 10 |
50 | 40 |
70 | 100 |
100 | 170 |
150 | 180 |
<tbody>
</tbody>
Last edited: