rolling average

[mikesingleton]

Is there a way to get a rolling average (last column)for each week (for the previous 12 weeks) without including the monthly subtotal (marked by 'Month Name, Year')??



11/3-11/7 99.52% 99.60%
11/10-11/14 99.44% 99.61%
11/17-11/21 99.81% 99.62%
11/24-11/28 98.21% 99.60%
November, 2003 99.36% 99.36%

12/1-12/5 99.66% 99.84%
12/8-12/12 100.00% 99.86%
12/15-12/19 99.39% 99.84%
12/22-12/26 100.00% 99.95%
12/29-12/31 100.00% 99.93%
December, 2003 99.79% 99.60%

1/5-1/9 100.00% 99.56%
1/12-1/16 99.17% 99.56%
1/19-1/23 100.00% 99.60%
1/26-1/30 96.48% 99.36%
January, 2004 98.91% 99.38%

2/2-2/6 100.00% 99.36%
2/9-2/13 100.00% 99.27%
2/16-2/20 100.00% 99.20%
2/23-2/27 100.00% 99.24%
February, 2004 100.00% 99.58%

 

[SkipVought]

Mike,

Check out the SUBTOTAL function with the appropriate Function Number. Nested SUBTOTALS are ignored to avoid double-dipping.

Skip,

Want to get great answers to your Tek-Tips questions? Have a look at faq222-2244