相同相聚 Get together with the same people (11790)

E2:E7{=INDEX(B:B,SMALL(IF(COUNTIF(E$1:E1,B$2:B$12)=0,ROW($2:$12),99),1))&""

F2:J7{=IFERROR(IF(COLUMN(A1)=1,"",",")&INDEX($C:$C,SMALL(IF($B$2:$B$12=$E2,ROW($2:$12)),COLUMN(A1)))&G2,"")



留言