How can it be easier to use formulas when you can do it in seconds using the
2 answers you got?

--
Regards,

Peo Sjoblom

(No private emails please)


"Charles P. (Pat) Upshaw" wrote in message
...
The easiest solution is to use a vlookup of the known values. I use the
fill procedure to establish all of the months. The known values are in
another table with the corresponding months. I use vlookup to find the
exact or previous value.

Sorry I made this sound more complicated than it was.

Thanks for the replies.

Pat Upshaw



"Charles P. (Pat) Upshaw" wrote in message
...
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