平均排名 (11865)

E2{=IFERROR(INDEX(B:B,RIGHT(LARGE(IF(MATCH(B$2:B$16,B:B,)=ROW($2:$16),INT(MMULT(N(B$2:B$16=TRANSPOSE(B$2:B$16)),C$2:C$16)/COUNTIF(B:B,B$2:B$16)/1%)/1%+ROW($2:$16)),ROW(A1)),2)),"")

F2{=IF(E2="","",AVERAGE(IF(B$2:B$16=E2,C$2:C$16)))