編號 依頁數累計 (14908)

D2=TEXT(SUM(B$1:B1)+1,REPT(0,C$2))&"-"&TEXT(SUM(B$1:B2),REPT(0,C$2))

另解=TEXT(MMULT(SUBTOTAL(9,OFFSET(B$1,,,ROW(A1)+{0,1}))+{1,0},10^IF({1;0},C$2,)),REPT(0,C$2)&"-"&REPT(0,C$2))



留言