編號 二列不重複 (8880)

E2{=A2&TEXT(SUM((MATCH(A$1:A2&B$1:B2,A$1:A2&B$1:B2,)=ROW($1:2))*(A$1:A2=A2))-1,"0;;")

若B列無排序 有變{=A2&TEXT(SUM((A2=A$2:A$19)*(B2>B$2:B$19)/COUNTIFS(A:A,A$2:A$19,B:B,B$2:B$19)),"0;;")