平均 刪指定最大 小數 (14056)

I2:M4{=AVERAGE(SMALL(IF(($A$2:$A$22=$H2)*($B$1:$F$1=I$1),$B$2:$F$22),ROW(INDIRECT($O$2+1&":"&COUNTIF($A:$A,$H2)-$O$2))))

格式化 條件符合 B2:F23=(COUNTIFS($A$2:$A$23,$A2,B$2:B$23,">"&B2)>=$O$2)*(COUNTIFS($A$2:$A$23,$A2,B$2:B$23,"<"&B2)>=$O$2)