I'm sure this is obvious, but here's the file showing how the formula can be applied to different date ranges. I prefer personally to use named ranges for large data as it manages it easier and is clearer to people when looking at the formula what is is being done. As an example I named the range of dates (to dates) from the first date all the way down randomly to the 1372 row and same for the hdd (named hdd). So any new dates and hdd values put in below your set provided will be within the range. You could name it for hundredes of thousands of cells if you want. Do you understand naming ranges? Let me know.
|