按比率 評定等級 (13881)

D2=LOOKUP(RANK(C2,C:C)/COUNT(C:C),SUBTOTAL(9,OFFSET(G$1,,,{1;2;3;4})),H$2:H$5)

E2=LOOKUP(ROUND(RANK(C2,C:C)/COUNT(C:C),1),SUBTOTAL(9,OFFSET(G$1,,,{1;2;3;4}))+0.01,H$2:H$5)