總和與取不重複字母 (13819)

L2{=INDIRECT(TEXT(MIN(IF(MOD(COLUMN(A:I),2)*(COUNTIF(L$1:L1,A$2:I$9)=0),ROW($2:$9)/1%+COLUMN(A:I)),999),"!R0C00"),)&""

M2=IF(L2="","",SUMIF(A:I,L2,B:J))



留言