FlameRetired - Looking at your suggestion closer, unfortunately in the end as you work down the list of advisors and you do a count of what shifts they worked after 52 weeks - There ends up being advisors that don't work a shift at all.
When I run this formula down column B all Advisors are accounted for.
What am I missing?
|
A |
B |
1 |
Team Mems |
|
2 |
Advisor 1 |
15 |
3 |
Advisor 2 |
15 |
4 |
Advisor 3 |
15 |
5 |
Advisor 4 |
15 |
6 |
Advisor 5 |
15 |
7 |
Advisor 6 |
15 |
8 |
Advisor 7 |
15 |
9 |
Advisor 8 |
15 |
10 |
Advisor 9 |
15 |
11 |
Advisor 10 |
15 |
12 |
Advisor 11 |
15 |
13 |
Advisor 12 |
15 |
14 |
Advisor 13 |
15 |
15 |
Advisor 14 |
15 |
16 |
Advisor 15 |
15 |
17 |
Advisor 16 |
15 |
18 |
Advisor 17 |
15 |
19 |
Advisor 18 |
15 |
20 |
Advisor 19 |
15 |
21 |
Advisor 20 |
15 |
22 |
Advisor 21 |
15 |
23 |
Advisor 22 |
15 |
24 |
Advisor 23 |
15 |
25 |
Advisor 24 |
15 |
26 |
Advisor 25 |
14 |
27 |
Advisor 26 |
14 |
28 |
Advisor 27 |
14 |
29 |
Advisor 28 |
14 |
Bookmarks