數字區間值 分別取出 (14838)

Q5:T12{=INDEX($2:$2,SMALL(IF(($B$2:$AN$2>=COLUMN(A1)*10-10)*($B$2:$AN$2<COLUMN(A1)*10),COLUMN($B:$AN),99),ROW(A1)))&""

另解{=INDEX($2:$2,SMALL(IF(COLUMN(A1)-LEFT(RIGHT(0&$B$2:$AN$2,2))=1,COLUMN($B:$AN),99),ROW(A1)))&""