D1=TEXT(SUMPRODUCT((SUMPRODUCT(--MID(SUBSTITUTE(A$1:A1,"集",),FIND("共",A$1:A1)+1,9))-IF({1,0},MID(SUBSTITUTE(A1,"集",),FIND("共",A1)+1,9),)+{1,0})*{1000,1}),"0!-000")
C1=(SUMPRODUCT(MID(SUBSTITUTE(A$1:A1,"集",),FIND("共",A$1:A1)+1,9)*1)-MID(SUBSTITUTE(A1,"集",),FIND("共",A1)+1,9)+1)&"-"&SUMPRODUCT(--MID(SUBSTITUTE(A$1:A1,"集",),FIND("共",A$1:A1)+1,9))
另解=IF(ROW()=1,"1-"&SUBSTITUTE(MID(A1,FIND("共",A1)+1,3),"集",),-IMAGINARY(INDIRECT("r[-1]c",)&"i")+1&"-"&-IMAGINARY(INDIRECT("r[-1]c",)&"i")+SUBSTITUTE(MID(A1,FIND("共",A1)+1,3),"集",))
集數最大2位數{=SUM(RIGHTB(SUBSTITUTE(A$1:A1,"集",),2)*1)-RIGHTB(SUBSTITUTE(A1,"集",),2)+1&SUM(-RIGHTB(SUBSTITUTE(A$1:A1,"集",),2))
留言
張貼留言