Hi guys,

New here, so apologies that my first post is a question but I am not that excel-savvy and any help you could give me would be greatly appreciated.

I have two tables of daily data consisting of two columns, the first being the date and the second being the associated value. I have daily data going back to 1990, so there are 5000+ rows of information; the data comes from two different countries and as such there are different public holidays with the result that the two tables do not tally directly.

I have two problems because of this:

1. Is there any way to have Excel arrange the tables so that the values match up against a list of all the weekdays between 01/01/90 and present day (I have created this list using the 'Fill Weekdays' function), leaving gaps where there is no data?

2. Where there are gaps is it possible to have Excel use the last given value?

Many thanks for your help all

John