小溪流向大海 发表于 2021-10-16 15:53:00

请教大佬，如何有公式，把数字从小到大顺序排列，谢谢！

顽强的小豆芽 发表于 2021-10-16 18:20:29

=TEXTJOIN(",",,IFERROR(AGGREGATE(15,6,--MID(SUBSTITUTE(C1,",",REPT(" ",99)),99*ROW($1:$99)-98,99),ROW($1:$99)),""))

尘心风舞 发表于 2021-10-23 19:25:59

=TEXTJOIN(",",1,TEXT(LARGE(-MID(SUBSTITUTE(C1&REPT(",0",9),",",REPT(" ",50)),ROW($1:$9)*50-49,50),ROW($1:$9)),"-0;0;"))

2019以上支持，且数据没有0

良陈美锦 发表于 2021-10-27 05:56:56

=TEXTJOIN(",",1,IFERROR(SMALL(IF(ISNUMBER(FIND(","&ROW($1:$999)&",",","&C1&",")),ROW($1:$999)),ROW($1:$999)),""))

起个名字想半天 发表于 2021-11-16 10:28:03

三位大佬的公式，问题得到解决，谢谢！

风云玄幻 发表于 2021-11-29 10:47:51

怎么号码越选越多？
=TEXTJOIN(",",,IF(1-ISERR(FIND(","&ROW($1:$33)&",",","&C1&",")),ROW($1:$33),""))

大山里的孩子 发表于 2021-12-1 06:22:42

=TEXTJOIN(",",,IF(1-ISERR(FIND(","&ROW($1:$33)&",",","&C1&",")),ROW($1:$33),""))跟楼上版主一样

神的游戏 发表于 2021-12-13 18:55:33

还是减2个吧：=TEXTJOIN(",",,IF(ISERR(FIND(","&ROW($1:$33)&",",","&C1&",")),"",ROW($1:$33)))
页: [1]
查看完整版本: 请教大佬，如何有公式，把数字从小到大顺序排列，谢谢！