D2=LEFT(LOOKUP("z",A$2:A2),2)&TEXT(SUMPRODUCT(N(LOOKUP("z",A$2:A2)=LOOKUP(ROW($1:1),ROW($1:1)/(A$1:A1<>""),A$1:A1))*N(+C$1:C1))+1,REPT(0,6))&" - "&LEFT(LOOKUP("z",A$2:A2),2)&TEXT(SUMPRODUCT(N(LOOKUP("z",A$2:A2)=LOOKUP(ROW($1:1),ROW($1:1)/(A$2:A2<>""),A$2:A2))*C$2:C2),REPT(0,6))
留言
張貼留言