接近平均值的得分計算 (14681)

H8=LOOKUP(SUMPRODUCT(N(ABS(AVERAGE($H7:$S7)-$H7:$S7)<ABS(AVERAGE($H7:$S7)-H7))),{0,1,2,3,4},{30,27,24,21,18})

H4:S4=ABS(AVERAGE($H7:$S7)-H7)

H5:S5=COUNTIF($H4:$S4,"<"&H4)+1

H7:S8格式化=H$8>18