排名彙整 同班相聚 依序一班 ~ 四班 分升降冪 (13286)

E2:F16{=INDEX(B:B,RIGHT(SMALL(FIND(LEFT($B$2:$B$16),"一二三四")/1%%-$C$2:$C$16/1%+ROW($2:$16),ROW(A1)),2))

H2:I16{=INDEX(B:B,RIGHT(SMALL(FIND(LEFT($B$2:$B$16),"一二三四")/1%%+$C$2:$C$16/1%+ROW($2:$16),ROW(A1)),2))