R3公式:=LEFT(TEXT(SUM((0&MID(TEXT(SUM(H3:Q3*10^(10-COLUMN($A:$J))),REPT("0",10)),SMALL(IF(COUNTIF(H3:Q3,H3:Q3)>1,IF(MATCH(H3:Q3,H3:Q3,)=COLUMN($A:$J),COLUMN($A:$J),11),11),ROW($1:$10)),1))*10^(10-ROW($1:$10))),REPT("0!,",10)),2*COUNT(IF(COUNTIF(H3:Q3,H3:Q3)>1,I...
|
