同部門取前2名 同值全取 聚同格 (13172)

F2 右拉 下拉 F欄是結果=IFERROR(IF(COLUMN(A1)=1,"",",")&INDEX($B:$B,RIGHT(LARGE(IF(($A$2:$A$16=$E2)*(LARGE(($A$2:$A$16=$E2)*$C$2:$C$16,2)<=$C$2:$C$16),$C$2:$C$16/1%+ROW($2:$16)),COLUMN(A1)),2))&G2,"")