魜来疯 发表于 2022-1-23 00:41:56

出错了，是不是因为：前面的2、1、4、3、0，这五个数值，都是通过函数取出来的数，所以出错了？实际我的表里面，2、1、4、3、0，是通过以下公式取的数：下面是A1中2的公式：
=LOOKUP(--LEFT(A10,2),{1,"1";2,"2";3,"3";4,"4";5,"5";6,"6";7,"7";8,"8";9,"9";10,"0";11,"1";12,"2";13,"3";14,"4";15,"5";16,"6";17,"7";18,"8";19,"9";20,"0";21,"1";22,"2";23,"3";24,"4";25,"5";26,"6";27,"7";28,"8";29,"9";30,"0";31,"1";32,"2";33,"3";34,"4";35,"5"})

山在那里 发表于 2022-1-24 20:59:55

上传附件、、

悦宁 发表于 2022-1-31 00:53:05

横向排序就好了啊

兵器零 发表于 2022-2-3 22:36:30

附件来了，谢谢

刘颜运 发表于 2022-2-7 15:12:11

格式问题
=SMALL(--$G$7:$K$7,COLUMN(A7))
数组，右拉
或者参照附件中修改一下第二个公式

紫叶飘絮 发表于 2022-2-8 22:58:53

=SMALL($G7:$K7*1,COLUMN(A1))这样？

财到手 发表于 2022-2-11 17:56:19

=LOOKUP(--LEFT(A10,2),{1,"1";2,"2";3,"3";4,"4";5,"5";6,"6";7,"7";8,"8";9,"9";10,"0";11,"1";12,"2";13,"3";14,"4";15,"5";16,"6";17,"7";18,"8";19,"9";20,"0";21,"1";22,"2";23,"3";24,"4";25,"5";26,"6";27,"7";28,"8";29,"9";30,"0";31,"1";32,"2";33,"3";34,"4";35,"5"})改成
=--LOOKUP(--LEFT(A10,2),{1,"1";2,"2";3,"3";4,"4";5,"5";6,"6";7,"7";8,"8";9,"9";10,"0";11,"1";12,"2";13,"3";14,"4";15,"5";16,"6";17,"7";18,"8";19,"9";20,"0";21,"1";22,"2";23,"3";24,"4";25,"5";26,"6";27,"7";28,"8";29,"9";30,"0";31,"1";32,"2";33,"3";34,"4";35,"5"})

达滔 发表于 2022-2-12 13:16:50

你那公式得出的数据，是文本数据，所以要改变成数据才行，公式前面加--就行了
页: 1 2 [3]
查看完整版本: 如何让几个不同格子的数值，从小到大排列？