Snasui Excel Forum

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

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

Thank you so much