Automating Fill series Function Multiple times ?
I hope someone can help me out.
I have a column of data with blank gaps for example somthing like the
following
15
46
55
32
21
48
59
I can manual select the value before the gaps/blank cells to the value after
the gaps so that they are highlighted and just do a Fill series function and
excel atuomaticly will interpolate values for the gaps. However I have a
rather large data set with lots of gaps and it is not very practical to do
this manualy for each gap in the column of data. I am have been trying to get
excell to automaticly do this for all the gaps, however have not found a
method to do this.
Any suggestions or help ?
Dan.
|