Excel: data missing in a seris of dates.... anybody can help?


Hi guys, I need a help with this time series and list of figure. I have a column of dates and hours. To each of them corresponds a figure.

column A column B
01/01/2011 00:00 40
01/01/2011 01:00 -98
01/01/2011 06:00 55
01/01/2011 18:00 45
Dates and hours are organized from the oldest to the most recent, but sometimes hours / dates are missing. I need to fill column B with zeros for those hours where the figure is missing.
column A column B
01/01/2011 00:00 40
01/01/2011 01:00 -98
01/01/2011 02:00 0
01/01/2011 03:00 0
01/01/2011 04:00 0
01/01/2011 05:00 0
01/01/2011 06:00 55
..... 0
....
thanks a lot! Best Amanda


This question generated 21 answers. To proceed to the answers, click here.

This thread is current as of March 24, 2014.


For more resources for Microsoft Excel