How to automatically fill in an average between two points . But only fill in the average when there is a blank cell

[jwalkerack]

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

Time

<tbody>
[TD="width: 64"]Distance [/TD]

[TD="align: right"]30[/TD]
[TD="align: right"]10[/TD]

[TD="align: right"]50[/TD]
[TD="align: right"]40[/TD]

[TD="align: right"]70[/TD]
[TD="align: right"]100[/TD]

[TD="align: right"]100[/TD]
[TD="align: right"]170[/TD]

[TD="align: right"]150[/TD]
[TD="align: right"]180[/TD]

</tbody>

 

[Domenic]

Assuming that A1:B11 contains the data, try the following..

1) Select cells A3:B11

2) On the ribbon, select Home > Editing > Find & Select > Go To Special > Blanks > OK

3) Then do the following...

Press =

Press (

Press the Up Arrow

Press +

Press the Down Arrow

Press )

Press /

Press 2

Press the Ctrl key down, and while the key is pressed down, press the ENTER key.

 

[jwalkerack]

Wow , cheers mate . That is great ,that is exactly what i have been looking for thank you very much

 

[Domenic]

You're very welcome! Thanks for the feedback!