Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Fill in missing months
I have a table containing periodic rates at monthly intervals from 1970.
Not all months have numbers, so I want those months rates to equal the previous month's rate. How do I "fill in" these blanks? Example: 01/1985 - 25.00 02/1985 03/1985 04/1985 - 29.25 05/1985 06/1985 07/1985 - 19.00 08/1985 09/1985 I have to do this over and over again, so I need a routine. I need for 02/1985 to equal 25.00; and 05/1985 to equal 29.25, etc. Thanks, Pat Upshaw |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel printing problem - won't print cell under a "fill effect" bo | Excel Discussion (Misc queries) | |||
Fill colour red | Excel Discussion (Misc queries) | |||
Missing lines in chart w/x-axis with months 1-24... | Charts and Charting in Excel | |||
How do i change 15 months to read 1 year and 3 months? | Excel Discussion (Misc queries) | |||
Identifying the Active Fill Color | Excel Discussion (Misc queries) |