班级升冪後 總分降冪 (15347)

F2:H16{=INDEX(B:B,RIGHT(SMALL(LEFTB($B$2:$B$16,2)*10^6-$D$2:$D$16/1%+ROW($2:$16),ROW(A1)),2))

J2:L16{=INDEX(B:B,RIGHT(LARGE($D$2:$D$16/1%+ROW($2:$16),ROW(A1)),2))