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

小溪流向大海

请教老师，如何有公式，把数字从小到大顺序排列，谢谢！.rar (7.93 KB, 下载次数: 193)

2021-10-16 15:53 上传

点击文件名下载附件
请教老师，如何有公式，把数字从小到大顺序排列，谢谢！.rar

顽强的小豆芽

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

尘心风舞

=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

良陈美锦

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

起个名字想半天

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

风云玄幻

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

大山里的孩子

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

神的游戏

还是减2个吧：=TEXTJOIN(",",,IF(ISERR(FIND(","&ROW($1:$33)&",",","&C1&",")),"",ROW($1:$33)))