去掉最高分和最低分计算平均分的表格.xlsVIP

Sheet3 Sheet2 Sheet1 X X X评分表 序号 班级 内容 评委1 评委2 评委3 评委4 评委5 评委6 评委7 去掉最高分 去掉最低分 选手得分 排名 1.00 .00 .00 2.00 2.00 .00 .00 3.00 .00 .00 4.00 .00 .00 5.00 .00 .00 6.00 .00 .00 7.00 .00 .00 8.00 .00 .00 9.00 .00 .00 10.00 .00 .00 11.00 .00 .00 12.00 .00 .00 13.00 .00 .00 14.00 .00 .00 15.00 .00 .00 16.00 .00 .00 17.00 .00 .00 18.00 .00 .00 19.00 .00 .00 20.00 .00 .00 21.00 .00 .00 22.00 .00 .00 23.00 .00 .00 24.00 .00 .00 25.00 .00 .00