SouthKaDaaku
New Member
Hi,
In my data set that contains percentages, I need to calculate their average on a day by day basis. With each passing day, the number of days needed to calculate the average will reduce. I need a solution where on dragging the formula rightwards, the number of days considered to calculate the average will reduce one by one automatically.
![83347 83347](https://chandoo.org/forum/data/attachments/83/83439-7a94ee006f9d4acd7eb226debd20d82d.jpg)
For example, the day 1 average will comprise of data from dates 1/1/ 2006 to 11/1/2006. 12/1/2006 will not be considered as data for that day is yet to be computed.
Similarly, the day 2 average will comprise of data from dates 1/1/ 2006 to 10/1/2006. 11/1/2006 and 12/1/2006 will not be considered as data for those days is yet to be computed.
Attaching the file for your perusal.
Thanks in advance!
In my data set that contains percentages, I need to calculate their average on a day by day basis. With each passing day, the number of days needed to calculate the average will reduce. I need a solution where on dragging the formula rightwards, the number of days considered to calculate the average will reduce one by one automatically.
![83347 83347](https://chandoo.org/forum/data/attachments/83/83439-7a94ee006f9d4acd7eb226debd20d82d.jpg)
For example, the day 1 average will comprise of data from dates 1/1/ 2006 to 11/1/2006. 12/1/2006 will not be considered as data for that day is yet to be computed.
Similarly, the day 2 average will comprise of data from dates 1/1/ 2006 to 10/1/2006. 11/1/2006 and 12/1/2006 will not be considered as data for those days is yet to be computed.
Attaching the file for your perusal.
Thanks in advance!
Attachments
Last edited by a moderator: