Most valuable professional
  • Hot Topics

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 1/1/2011 1/1/2011 1:00:00 AM 1/1/2011 6:00:00 AM 1/1/2011 6:00:00 PM 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 1/1/2011 1/1/2011 1:00:00 AM 1/1/2011 2:00:00 AM 1/1/2011 3:00:00 AM 1/1/2011 4:00:00 AM 1/1/2011 5:00:00 AM 1/1/2011 6:00:00 AM ..... .... 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:

This article includes the following tags:

  • Excel
  • Microsoft Excel