Different Dates

Hi everyone,

I need a helping hand with cleaning my time-series data as I have to collect a couple of variables on a daily basis between 2005-2010. However, some of the variables don't have matching dates, e.g the London Stock Exchange doesn't record the closing value of the FTSE100 index on weekends/no-trading days whereas pollution stations around the city measure levels of pollution every day. Is there any way I can use the dates of the FTSE100 as the only date axis/column and delete the dates from column A that don't match with the ftse100 dates? I could go manually but then I need to do this for another 8 years of daily observations and will be too complicated/time consuming to do it manually and I need this data clean for my final year econ dissertation. Thanks in advance.

Administrative Note:

Welcome to the forum.

Unfortunately, this is a duplicate thread, and you are allowed only ONE thread per issue here.

Please see Forum Rule #5 about thread duplication.

I am closing this thread, but you may continue here in the original thread:https://www.excelforum.com/excel-for...ent-dates.html