Excel中总人数去掉10%(最低分)怎样算总分?
Excel中总人数去掉10%(最低分)怎样算总分?
是这样做的:=G76-SMALL(C4:C73,1)-SMALL(C4:C73,2)-SMALL(C4:C73,3)-SMALL(C4:C73,4)-SMALL(C4:C73,5)-SMALL(C4:C73,6)-SMALL(C4:C73,7)-SMALL(C4:C73,8)-SMALL(C4:C73,9)-SMALL(C4:C73,10)-SMALL(C4:C73,11)-SMALL(C4:C73,12)-SMALL(C4:C73,13).G76是实际总分.弄了前13个最低分.比如应去掉5人,就计算:=G76-SMALL(C4:C73,1)-SMALL(C4:C73,2)-SMALL(C4:C73,3)-SMALL(C4:C73,4)-SMALL(C4:C73,5).一次一改.