drop list

[sna]

Dear ,
I need a solution to a problem
1) if we select any name from drop dwon list J3 then list of all traning atteneded by that person will come .
2) If we select any traning name from drop dwon K3 then all name list come who atttend that training.
2) If we select any traning name from drop down L3 then all name list come who not atttend that training.


TY

[snasui]

Try with these formulas

1. J4
   =IFERROR(INDEX($2:$2,AGGREGATE(15,6,COLUMN($B$2:$H$2)/(INDEX($B$3:$H$11,MATCH(J$3,$A$3:$A$11,0),0)="Y"),ROWS(J$3:J3))),"")
   Enter > Copy down
2. K4
   =IFERROR(INDEX(A:A,AGGREGATE(15,6,(ROW($A$3:$A$11))/(INDEX($B$3:$H$11,0,MATCH(K$3,$B$2:$H$2,0))="Y"),ROWS(J$3:J3))),"")
   Enter > Copy down
3. L4
   =IFERROR(INDEX(A:A,AGGREGATE(15,6,(ROW($A$3:$A$11))/(INDEX($B$3:$H$11,0,MATCH(L$3,$B$2:$H$2,0))=""),ROWS(J$3:J3))),"")
   Enter > Copy down

[sna]

Thank you so much