合併格數不一樣 計總和後排名 (14542)

G2全下拉才正確=IF(B2="","",SUM(D2:F14)-SUM(G3:G14))

J2{=INDEX(B:B,RIGHT(LARGE(IF(G$2:G$14<>"",G$2:G$14/1%+ROW($2:$14)),ROW(A1)),2))

K2=VLOOKUP(J2,B:G,6,)

M2{=INDEX(B:B,RIGHT(LARGE(MMULT(COLUMN(A:M)^0,(LOOKUP(ROW(2:14),ROW(2:14)/(B$2:B$14<>""),B$2:B$14)=TRANSPOSE(B$2:B$14))*MMULT(D$2:F$14,{1;1;1}))/1%+COLUMN(B:N),ROW(A1)),2))

N2=SUMPRODUCT((LOOKUP(ROW(2:14),ROW(2:14)/(B$2:B$14<>""),B$2:B$14)=M2)*MMULT(D$2:F$14,{1;1;1}))