更新时间2021-12-29 18:43:09
excel中,若A1=a且B1=b,则依次编号为A-001,A-002……;若A1=c且B1=b,则依次编号为B-001,B-002……
=IF(D1="ab","A-"&TEXT(COUNTIF($D$1:D1,D1),"000"),
IF(D1="cb","B-"&TEXT(COUNTIF($D$1:D1,D1),"000"),
""))
情况列举的不完全
=IFERROR(IF(A1="a","A-",IF(A1="c","B-",0/0))&TEXT(COUNTIF($A$1:A1,A1),"000"),"")
上一篇:跪求EXCEL公式
下一篇:(36!)/(7!)=