各班統計 前後名次人數 (15389)

M2:N4=SUMPRODUCT(($B$2:$B$26=$L2)*(MMULT($D$2:$G$26,{1;1;1;1})*-1^(M$1=$N$1)>=LARGE(MMULT($D$2:$G$26,{1;1;1;1})*-1^(M$1=$N$1),$J$2)))

M11:N13=SUMPRODUCT(($B$2:$B$26=$L11)*($H$2:$H$26*-1^(M$1=$N$1)<=SMALL($H$2:$H$26*-1^(M$1=$N$1),$J$2)))