評定等級換算分數 加權後排名 (14520)

J3{=INDEX(B:B,RIGHT(LARGE(MMULT(SUMIF(M$2:M$6,C$3:G$9,N$2:N$6)*C$2:G$2,{1;1;1;1;1})/1%%+ROW($3:$9),ROW(A1)),2))

K3{=SUM(VLOOKUP(T(IF({1},VLOOKUP(J3,B:G,{2,3,4,5,6},))),M:N,2,)*C$2:G$2)

H3=SUMPRODUCT(SUMIF(M$2:M$6,C3:G3,N$2:N$6)*C$2:G$2)