排名 各部門連續與跳號 (13147)

C2=COUNTIFS(A:A,A2,B:B,">"&B2)+1

D2=SUMPRODUCT((A$2:A$15=A2)*(B$2:B$15>B2)/COUNTIFS(A:A,$A$2:$A$15,B:B,B$2:B$15))+1