阿土伯张 发表于 2021-11-4 17:32:00

如何让几个不同格子的数值，从小到大排列？

如何让几个不同格子的数值，从小到大排列？
如下：A1-E1中分别为2、1、4、3、0，如何让H1-L1中，变为0、1、2、3、4从小到大排列？

东小邪 发表于 2021-11-13 16:42:21

=small($a$1:$e$1,column(a1))

如果相遇 发表于 2021-11-14 22:18: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"})

勾伟 发表于 2021-11-17 07:09:16

上传附件、、

君越纺织 发表于 2021-11-20 19:12:52

横向排序就好了啊

丰庆包粥道 发表于 2021-11-30 03:47:12

附件来了，谢谢

扬州唐哥 发表于 2021-12-8 00:09:32

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

红梅千雪 发表于 2021-12-9 02:29:29

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

无极翟磊 发表于 2021-12-11 08:09:46

=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"})

坚强不息 发表于 2021-12-18 17:02:30

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