編部門 依分數高低 (Editing department according to score) (11909)

C2=LOOKUP(RANK(B2,B:B)/COUNT(B:B),SUBTOTAL(9,OFFSET(G$1,,,{1;2;3;4}))+1%%,F$2:F$5)