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

阿土伯张

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

东小邪

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

如果相遇

出错了，是不是因为：前面的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"})

勾伟

上传附件、、

君越纺织

横向排序就好了啊

丰庆包粥道

附件来了，谢谢
新建 XLS 工作表.zip (6.51 KB, 下载次数: 12)

2021-11-4 17:32 上传

点击文件名下载附件
新建 XLS 工作表.zip

扬州唐哥

格式问题
=SMALL(--$G$7:$K$7,COLUMN(A7))
数组，右拉
或者参照附件中修改一下第二个公式
新建 XLS 工作表.rar (6.61 KB, 下载次数: 103)

2021-11-4 17:32 上传

点击文件名下载附件
新建 XLS 工作表.rar

红梅千雪

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

无极翟磊

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

坚强不息

你那公式得出的数据，是文本数据，所以要改变成数据才行，公式前面加--就行了