不重複姓名 彙整表格 (13804)

G2:G8 (取不重複姓名){=INDIRECT(TEXT(MIN(IF(COUNTIF(G$1:G1,$B$2:$C$7)=0,ROW($2:$7)/1%+{2,3},999)),"!R0C00"),)&""

H2:H8=IF(G2="","",SUM(SUMIF(B:C,G2,D:E)))

I2:K8{=IFERROR(REPT(",",COLUMN(A1)>1)&INDEX($A:$A,SMALL(IF($B$2:$C$7=$G2,ROW($2:$7)),COLUMN(A1)))&J2,"")