排名 同分五項目依順序 (9280)

F2=SUM(N(MMULT(A$2:E$5,10^{3;2;1;0;5})>=MMULT(A2:E2,10^{3;2;1;0;5})))

另解=SUMPRODUCT(N(E2&A2&B2&C2&D2<=E$2:E$5&A$2:A$5&B$2:B$5&C$2:C$5&D$2:D$5))