excel一行数值按从大到小排列公式?答:在P15输入公式:=IF(ISERR(LARGE(IF(MATCH($E15:$N15,$E15:$N15,0)=COLUMN($E15:$N15)-4,$E15:$N15),COLUMN(A1))),"",LARGE(IF(MATCH($E15:$N15,$E15:$N15,0)=COLUMN($E15:$N15)-4,$E15:$N15),COLUMN(A1)))摁键盘上的 shift+ctrl+回车 三个组合键结束公式的输入,再...
...10,50,40,30,70,60,80,90,100}进行从大到小的排序答:public class a { public static void main(String[] arg){ int a[]={20,10,50,40,30,70,60,80,90,100} int i,n,max;for(i=0;i<=8;i++){ for(n=i+1;n<=9;n++){ if(a[i]<a[n]){ max=a[i];a[i]=a[n];a[n]=max;} } } for(i=0;i<=9;i++){ System...