Good Day all I have two work sheets, one contains data tab and the other an overview tab with a table to count the amount of times a number is listed per month, and 7 day week, when the month or week 1-4 is inputted. Please see example below:
Data Table
Overview tab with the count table:
.
Input Table:
Whereby Jan displays the count for January and Feb For February and Week with a zero value displays the complete month, week 1 displays the first week and week 2 the second etc.
Data Table
the project M.xlsm | |||||
---|---|---|---|---|---|
B | C | D | |||
1 | Date | Time | Num | ||
2 | 2-Jan-23 | Morning | 33 | ||
3 | 2-Jan-23 | Midday | 21 | ||
4 | 2-Jan-23 | Afternoon | 4 | ||
5 | 2-Jan-23 | Evening | 1 | ||
6 | 3-Jan-23 | Morning | 2 | ||
7 | 3-Jan-23 | Midday | 15 | ||
8 | 3-Jan-23 | Afternoon | 32 | ||
9 | 3-Jan-23 | Evening | 22 | ||
10 | 4-Jan-23 | Morning | 27 | ||
11 | 4-Jan-23 | Midday | 5 | ||
12 | 4-Jan-23 | Afternoon | 32 | ||
13 | 4-Jan-23 | Evening | 35 | ||
14 | 5-Jan-23 | Morning | 18 | ||
15 | 5-Jan-23 | Midday | 12 | ||
16 | 5-Jan-23 | Afternoon | 15 | ||
17 | 5-Jan-23 | Evening | 11 | ||
18 | 6-Jan-23 | Morning | 19 | ||
19 | 6-Jan-23 | Midday | 12 | ||
20 | 6-Jan-23 | Afternoon | 2 | ||
21 | 6-Jan-23 | Evening | 20 | ||
22 | 7-Jan-23 | Morning | 36 | ||
23 | 7-Jan-23 | Midday | 36 | ||
Data |
Overview tab with the count table:
the project M.xlsm | ||||||||
---|---|---|---|---|---|---|---|---|
M | N | O | P | Q | R | |||
18 | Count | |||||||
19 | 1 | 1 | 13 | 25 | ||||
20 | 2 | 1 | 14 | 26 | ||||
21 | 3 | 15 | 2 | 27 | 1 | |||
22 | 4 | 1 | 16 | 28 | ||||
23 | 5 | 1 | 17 | 29 | ||||
24 | 6 | 18 | 1 | 30 | ||||
25 | 7 | 19 | 1 | 31 | ||||
26 | 8 | 20 | 1 | 32 | 2 | |||
27 | 9 | 21 | 1 | 33 | 1 | |||
28 | 10 | 22 | 1 | 34 | ||||
29 | 11 | 1 | 23 | 35 | 1 | |||
30 | 12 | 2 | 24 | 36 | 2 | |||
Overview |
Input Table:
the project M.xlsm | ||||
---|---|---|---|---|
A | B | |||
1 | Input | |||
2 | ||||
3 | Month | Jan | ||
4 | Week | 1 | ||
Overview |
Whereby Jan displays the count for January and Feb For February and Week with a zero value displays the complete month, week 1 displays the first week and week 2 the second etc.