excel中 如何将一组数据中的三个最大值和三个最小值剔除后求平均值?求...答:无重复数值情况下 =(if(or(rank(a1,a1:a10,0)<=3,rank(a1,A1:A10,0)>=(COUNT(A1:A10))-3),0,a1)+if(or(rank(a2,a1:a10,0)<=3,rank(a2,A1:A10,0)>=(COUNT(A1:A10))-3),0,a2)+if(or(rank(a3,a1:a10,0)<=3,rank(a3,A1:A10,0)>=(COUNT(A1:A10))...