比如说:原来是101101102201201301301变成101101二102201201二301301二excel中如何批量实现这个操作
公式:
=A1&IF(COUNTIF(A$1:A1,A1)>1,NUMBERSTRING(COUNTIF(A$1:A1,A1),1),"")
B2: =IF(COUNTIF(A$2:A2,A2)>1,A2&TEXT(COUNTIF(A$2:A2,A2),"0[DBNum1]"),"")
下拉