excel序号1,1.1,1.2,1.2.1,1.2.2，怎么分级排序

leepoison · 发表于 2025-5-9 16:46

=IFNA(REDUCE(TAKE(TRIMRANGE(A:A),1),SEQUENCE(ROWS(TRIMRANGE(A:A))-1),LAMBDA(m,n,VSTACK(m,LET(a,SUBSTITUTES(TRIMRANGE(A:A),"."),MAP(SEQUENCE(,9),LAMBDA(x,IF(CHOOSECOLS(MID(CHOOSEROWS(a,n+1),SEQUENCE(,10),1),x)=CHOOSECOLS(MID(CHOOSEROWS(a,n),SEQUENCE(,10),1),x),"",CHOOSECOLS(MID(CHOOSEROWS(a,n+1),SEQUENCE(,10),1),x)))))))),"")

那天的月亮 · 发表于 2025-5-9 17:30

函数公式:B4
=SUBSTITUTE(REGEXP(A4,"[.]|\d$"),".",)

函数公式:B4
=IFERROR(
HSTACK(
EXPAND("", , LEN(REGEXP(A4, "[^\d]+", 2)) - 1, ""),
REGEXP(A4, "\d$")
),
A4
)

		自动登录	找回密码
密码			免费注册

[求助] excel序号1,1.1,1.2,1.2.1,1.2.2，怎么分级排序

浏览过的版块