Hi!

I have a big problem in Excel (version 2003). I wonder if you could help me.
I have 2 very long time-series in coloumns B and D, and the dates of these
daily datas in coloumns A and C. They start at the same day, but the problem
is, that while the first time-series has a value for every day, the second
one skips weekends and holidays, so by the end there is a really wide time
gap between the dates in a single row. However I must do statistical
comparison for datas of the same day, so I'd like to adjust the second series
to the first one. The missing days of the second series would take the values
of the last real data. Doing this manually would take many hours, so I'm
desperate. I really don't know if there is a solution, but I would really
appreciate any help! Please helo me!

Thanks in advance!
Roland