同批號相聚 後尾號各別排序 (12339)

F2:H15{=INDEX(B:B,RIGHT(SMALL($C$2:$C$15/1%%+$B$2:$B$15/1%+ROW($2:$15),ROW(A1)),2))

批號先出現 排上面 O2:Q15{=INDEX(K:K,RIGHT(SMALL(MATCH($L$2:$L$15,$L:$L,)/1%%+$K$2:$K$15/1%+ROW($2:$15),ROW(A1)),2))