scotthannaford1973
Board Regular
- Joined
- Sep 27, 2017
- Messages
- 114
- Office Version
- 2010
- Platform
- Windows
Hi all
okay hope you can help here... A3:G15 shows a list of projects and project teams; if they are involved in a project in a particular month, there is a 1 beside the team name for that month; if not, there is a 0.
Cell J1 is a drop-down where I can specify the team; what I'd like is that below each month (I3:L3) to list all of the projects where the Team's involvement = 1 and its a dynamic list depending on what's in J1
for example, in J (Jan-21), with Support selected, there would be a list of Project A and Project B
No idea how to do this, so any pointers gratefully received!
okay hope you can help here... A3:G15 shows a list of projects and project teams; if they are involved in a project in a particular month, there is a 1 beside the team name for that month; if not, there is a 0.
Cell J1 is a drop-down where I can specify the team; what I'd like is that below each month (I3:L3) to list all of the projects where the Team's involvement = 1 and its a dynamic list depending on what's in J1
for example, in J (Jan-21), with Support selected, there would be a list of Project A and Project B
No idea how to do this, so any pointers gratefully received!
A | B | C | D | E | F | G | H | I | J | K | L |
1 | Team name | Support | |||||||||
2 | |||||||||||
3 | Project Name | Team Name | Dec-20 | Jan-21 | Feb-21 | Mar-21 | Dec-20 | Jan-21 | Feb-21 | Mar-21 | |
4 | Project A | Training | 1 | 0 | 1 | 0 | |||||
5 | Project A | Dev | 1 | 0 | 0 | 0 | |||||
6 | Project A | Support | 1 | 1 | 1 | 1 | |||||
7 | Project A | Testing | 1 | 1 | 0 | 0 | |||||
8 | Project B | Training | 1 | 0 | 0 | 0 | |||||
9 | Project B | Dev | 1 | 1 | 1 | 1 | |||||
10 | Project B | Support | 1 | 1 | 0 | 0 | |||||
11 | Project B | Testing | 1 | 0 | 0 | 0 | |||||
12 | Project C | Training | 1 | 1 | 1 | 1 | |||||
13 | Project C | Dev | 1 | 1 | 0 | 0 | |||||
14 | Project C | Support | 1 | 0 | 1 | 0 | |||||
15 | Project C | Testing | 1 | 0 | 1 | 0 |