Assume you've spaced your data as below and want to fill in the missing values.
Code:
--A-- --B-- --C-- --D-- --E-- --F-- --G-- --H-- --I-- --J--
1 0 4000 8000
2 220 2.8 4.8 6.8
3
4 200 3.1 5.1 7.1
5
6 180 2.9 4.9 6.9
Here are two relatively simple methods:
A) Fill individual ranges using Series command...
1) Select B1:F2 then from the Home Tab on the ribbon choose Fill > Series, check Trend and Series in Rows, OK.
2) Repeat for F1:J2, B4:F4, F4:J4, B6:F6, F6:J6. (*)
3) Select A2:J4, A4:J6 then choose Fill > Series, check Trend and Series in Columns, OK.
*A quick way is to select all the ranges together by holding down Ctrl (note that the ranges will overlap at the end points) then choose the Fill > Series command
B) Use simple formulas with iteration set...
1) Under Excel Options in the File or Office button tab Check Enable Iterative Calculation, Max Change: 0
2) Select (A3:J3, A5:J5) and with A3 as the active cell type =(A2+A4)/2 and press ctrl+enter to fill the range.
3) Select (C1:E6, G1:I6) and with C1 as the active cell type =(B1+D1)/2 and press ctrl+enter to fill the range.
4) Select the range and copy/ Paste Special Values, then uncheck Enable Iterative Calculation.
ffice
></o
