如题所述
如图,B3输入:=LARGE($A$3:$A$10,ROW(1:1)),下拉,从大到小排序;
D3输入:=IF($D$1=SUM($D$2:D2),0,IF(ROUND(C3,0)<1,1,ROUND(C3,0))),下拉;
E3输入:=IF(SUM($D$3:$D$10)<$D$1,D3-SUM($D$3:$D$10)+$D$1,D3),
E4输入:=D4,下拉至E9;
E10输入:=IF(SUM($D$3:$D$10)>$D$1,D10-SUM($D$3:$D$10)+$D$1,D10)