彙整表格 (12532)

2007版 F2:I7{=IFERROR(IF(COLUMN(A1)=1,""," ,")&INDEX($B:$B,SMALL(IF(TRIM(MID(SUBSTITUTE($C$2:$C$5,",",REPT(" ",99)),COLUMN($A:$I)*99-98,99))=$E2,ROW($2:$5)),COLUMN(A1)))&G2,"")