Creating a list based on cell contents

[scotthannaford1973]

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!

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

 

[Fluff]

Glad we could help & thanks for the feedback.