梁月 发表于 2021-12-30 05:59:41

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

路人甲干上路人乙 发表于 2022-1-2 19:22:39

出错了，是不是因为：前面的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-3 22:01:19

上传附件、、

道友留步 发表于 2022-1-9 00:45:58

横向排序就好了啊

闲逛的麦田 发表于 2022-1-9 21:55:51

附件来了，谢谢

到不了的 发表于 2022-1-10 07:56:59

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

豪扬文具 发表于 2022-1-10 16:22:29

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

丁磊 发表于 2022-1-12 03:14:44

=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-1-19 13:12:15

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

篮球大可乐 发表于 2022-1-21 22:54:40

=small($a$1:$e$1,column(a1))
页: 1 [2] 3
查看完整版本: 如何让几个不同格子的数值，从小到大排列？