平均計算後 排名 (15316)

F2{=IFERROR(INDEX(B:B,RIGHT(LARGE(IF(MATCH(B$2:B$16,B:B,)=ROW($2:$16),ROUND(SUMIF(B:B,B$2:B$16,D:D)/COUNTIF(B:B,B$2:B$16),2)/1%%+ROW($2:$16)),ROW(A1)),2)),"")

G2{=IF(F2="","",AVERAGE(IF(B$2:B$16=F2,D$2:D$16)))