如何整理每場活動的參加名單 (11430)

G2:M6{=INDEX($A:$A,SMALL(IF(1-ISERR(FIND(","&SUBSTITUTE(G$1,"名單",)&",",","&SUBSTITUTE($B$2:$B$6," ",)&",")),ROW($2:$6),99),ROW(A1)))&""



留言