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

魜来疯

出错了，是不是因为：前面的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, 下载次数: 15)

2021-11-4 17:32 上传

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

刘颜运

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

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

达滔

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