详细问题描述及疑问:期待您的答案,真心佩服你,谢谢 !
=来自AVERAGEIFS(A1:A20,A1:A20,"<"&LARGE(A1:A20,INT(COUNT(A1:A20)*20%)),A1:A20,">"&SMALL(A1:A20,INT(COUNT(A1:A20)*10%)))
均任黑古哪输=SUM(B:B善继云振运朝执*(COUNT(B:B)*0.2<=RANK(B:B,B:B))*(COUNT(B:B)*0.9>=RANK(B:B,B:B))*(ISNUMBE去罪吃息植承降补着R(B:B)))/SUM((COUNT(B:B)*0.2<=RANK(政鲁千维孙集顺考经厂宜B:B,B:B))*(参振益雨思缺权已甚COUNT(B:B)含种执告故苦宜置应哥算*0.9>=RANK(B:B,B:B))*(ISNUMBER(B:B)))数组公式,输入完成Ctrl+Shift+回车