三个条件各自编号 (8994)

 

  D2 (跳多號)=COUNTIFS(A:A,A2,B:B,B2,C:C,"<"&C2)+1

E2 (緊接號 +1)=SUMPRODUCT((A$2:A$21=A2)*(B$2:B$21=B2)*(C$2:C$21<C2)/COUNTIFS(A:A,A$2:A$21,B:B,B$2:B$21,C:C,C$2:C$21))+1