排名 多名同分下一位依序 (12135)

E2=SUMPRODUCT((C$2:C$16=C2)*(D$2:D$16>D2)/COUNTIFS(C:C,C$2:C$16,D:D,D$2:D$16))+1



留言