LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Charles P. \(Pat\) Upshaw
 
Posts: n/a
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel printing problem - won't print cell under a "fill effect" bo dmotika Excel Discussion (Misc queries) 0 May 26th 05 04:38 PM
Fill colour red Dave Excel Discussion (Misc queries) 2 May 14th 05 12:08 PM
Missing lines in chart w/x-axis with months 1-24... DendWrite Charts and Charting in Excel 2 May 10th 05 09:04 PM
How do i change 15 months to read 1 year and 3 months? Marty Excel Discussion (Misc queries) 1 February 17th 05 11:21 PM
Identifying the Active Fill Color Steve Conary Excel Discussion (Misc queries) 3 December 9th 04 04:45 AM


All times are GMT +1. The time now is 11:39 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"