A2=COUNTIF($A$1:$J$1,A1)右拉至J2A3=IF(A2=1,"",COLUMN())右拉至J3A4=A3B4=A4&B3右拉至J4K1=J4
例如:
或
K1=SUBSTITUTE(MID(SUMPRODUCT((COUNTIF(A1:J1,A1:J1)>1)*(COLUMN(A1:J1)<10)*COLUMN(A1:J1)*10^-COLUMN(A1:J1)),3,10),"0","")&IF(COUNTIF(A1:J1,J1)>1,"10","")
则不需要辅助行了.
例如: