名次重複 往下取分 平均 (11008)

C2{=AVERAGE(IF(B$2:B$9=B2,LOOKUP(B$2:B$9+COUNTIF(OFFSET(B$2,,,ROW($1:$8)),B$2:B$9)-1,F:F,G:G)))

另解=SUMPRODUCT((B$2:B$9=B2)*G$2:G$9/COUNTIF(B$2:B$9,B$2:B$9))