- 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:
- Microsoft Excel