續不續號 用符號 (10483)

E1下拉 E1是結果{=IFERROR(IF(ROW(A1)=1,"","&")&INDEX(D:D,SMALL(IF(IFERROR(D$3:D$19-D$2:D$18,9)>1,ROW($3:$19)),ROW(A1)))&"-"&INDEX(D:D,SMALL(IF(D$4:D$19-D$3:D$18<>1,ROW($3:$18)),ROW(A1)))&E2,"")