連續相同數字 分欄取出 (13719)

C2{=IF(B2="","",IF(COUNTIF(B1:B3,B2)>1,MAX(N(+C$1:C1))+(B2<>B1),))

E2右拉 下拉{=INDEX($B:$B,SMALL(IF($C$2:$C$99=COLUMN(A1),ROW($2:$99),99),ROW(A1)))&""