I am trying to find the frequency of lottery numbers that occur within 10-day periods (see row 7).
Instead of having to manually write each formula for each column, is there a way I can automate it, so that each column will "advance" 10 days?
Instead of having to manually write each formula for each column, is there a way I can automate it, so that each column will "advance" 10 days?
Excel 2012 | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | |||
1 | ct | 0 | 1 | 2 | 3 | 4 | 5 | 6 | ||
2 | date_am | 5/30/2013 | 5/29/2013 | 5/28/2013 | 5/27/2013 | 5/26/2013 | 5/25/2013 | 5/24/2013 | ||
3 | N1 | 3 | 3 | 4 | 7 | 4 | 0 | 5 | ||
4 | N2 | 1 | 3 | 2 | 2 | 6 | 6 | 0 | ||
5 | N3 | 2 | 3 | 8 | 9 | 9 | 6 | 8 | ||
6 | ||||||||||
7 | ball | d10 | d20 | d30 | d40 | d50 | d60 | d70 | ||
8 | 0 | 1 | 2 | |||||||
9 | 1 | 1 | 2 | |||||||
10 | 2 | 0 | 1 | |||||||
11 | 3 | 2 | 2 | |||||||
12 | 4 | 2 | 0 | |||||||
13 | 5 | 2 | 1 | |||||||
14 | 6 | 0 | 2 | |||||||
15 | 7 | 2 | 0 | |||||||
16 | 8 | 0 | 0 | |||||||
17 | 9 | 0 | 0 | |||||||
18 | ||||||||||
19 | sum | 10 | 10 | |||||||
am |