=SUBSTITUTE(LEFT(A1,10)&".001-"&TEXT(SUM(IF(LEFT($A$1:$A$8,10)=LEFT(A1,10),1)),"000"),"001-001","001")空白列输入上公式，同时按shift ctrl enter结束（数组公式），数据区域依具体而设置
A1输入="DC"&61092200000000+ROW(A1)向下填充，即可
