E2=SUMPRODUCT((B$2:B$19=B2)*(SUMIFS(D:D,A:A,A$2:A$19,B:B,B$2:B$19,C:C,C$2:C$19)>=SUMIFS(D:D,A:A,A2,B:B,B2,C:C,C2))*(MATCH(A$2:A$19&B$2:B$19&C$2:C$19,A$2:A$19&B$2:B$19&C$2:C$19,)=ROW($1:$18)))
=SUMPRODUCT((A$2:A$19=A2)*(B$2:B$19=B2)*(SUMIFS(D:D,A:A,A$2:A$19,B:B,B$2:B$19,C:C,C$2:C$19)>SUMIFS(D:D,A:A,A2,B:B,B2,C:C,C2))/COUNTIFS(A$2:A$19,A$2:A$19,B$2:B$19,B$2:B$19,C$2:C$19,C$2:C$19))+1
留言
張貼留言