Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Fill Series function question | Excel Worksheet Functions | |||
fill series of multiple rows and columns | Excel Discussion (Misc queries) | |||
Fill Series Dates: not letting me change the series from year to m | Excel Discussion (Misc queries) | |||
Automating a series of dates for two columns? | Excel Worksheet Functions | |||
Upper / Fill Series Function in Excel | Excel Discussion (Misc queries) |