如何统计连续的数值 (12551)

D2{=IFERROR(INDEX(B:B,SMALL(IF(IFERROR(B$2:B$10-B$1:B$9,9)>1,ROW($2:$10)),ROW(A1)))&"-"&INDEX(B:B,SMALL(IF(B$3:B$11-B$2:B$10<>1,ROW($2:$10)),ROW(A1))),"")



留言