G2=LARGE($C$2:$C$16,ROW(A1))向下复制
D2=C2&COUNTIF(C$2:C2,C2)向下复制
E2=VLOOKUP($G2&COUNTIF($G$2:$G2,$G2),IF({1,0},$D$2:$D$16,A$2:A$16),2,0)向下向右复制
G2=LARGE($C$2:$C$16,ROW(A1))向下复制
D2=C2&COUNTIF(C$2:C2,C2)向下复制
E2=VLOOKUP($G2&COUNTIF($G$2:$G2,$G2),IF({1,0},$D$2:$D$16,A$2:A$16),2,0)向下向右复制
