Hello community
I am stuck at a very basic problem. I have an hourly data (0.00 hour to 23:00 hour for whole year) for 3 years and every midnight 0.00 hour the data is missing. I need to find average of next 23 hours to substitute at 0.00 hours (same calendar day) so I have complete data and I can use my mathematical models.
If I go by conventional way of finding average it will take a huge time. Is there a formula that can help for the whole worksheet?
Thank you very much in advance
Eve
Bookmarks