G2{=SUM(IFERROR((B$2:B$19=F2)/COUNTIFS(B:B,B$2:B$19,C:C,C$2:C$19),))
另解=SUMPRODUCT((B$2:B$19=F2)*(C$2:C$19<>"")/COUNTIFS(B:B,B$2:B$19,C:C,C$2:C$19&""))
另解{=COUNT(0/(MATCH(B$2:B$19&C$2:C$19,B$2:B$19&C$2:C$19,)=ROW($1:$18))/(C$2:C$19<>"")/(B$2:B$19=F2))
留言
張貼留言