请教如何才能实现处理后的效果?

shadow792

如题,谢谢各位高手.

szl3178

1. =TEXTJOIN("/",,"XLI2512"&DROP(GROUPBY(RIGHT(A2:A12,2)-ROW(1:11),RIGHT(A2:A12,2),LAMBDA(x,@x&"-"&TAKE(x,-1))),-1,1))

复制代码

无关岁月

1. =LET(x,RIGHT(A2:A12,2),TEXTJOIN("/",,LEFT(A2,7)&DROP(REGEXREPLACE(GROUPBY(x-ROW(1:11),-x,CONCAT,,0),"^-|-\d+(?=-)",),,1)))

复制代码

快乐王子238

=LET(data,SORT(A2:A12),arr,1*SUBSTITUTE(data,"XLI",""),brr,SEQUENCE(ROWS(data)),crr,arr-brr,drr,MAP(UNIQUE(crr),LAMBDA(x,LET(aa,XLOOKUP(x,crr,data),bb,XLOOKUP(x,crr,data,,,-1),IF(aa=bb,aa,TEXTJOIN("-",,aa,RIGHT(bb,2)))))),TEXTJOIN("/",,drr))

mykitami

=LET(_a,--RIGHT(A2:A12,2),_b,_a-SEQUENCE(ROWS(_a)),TEXTJOIN("/",,LEFT(A2,7)&DROP(GROUPBY(_b,_a,LAMBDA(x,@x&IF(ROWS(x)>1,"-"&MAX(x),)),,0),,1)))

你是那块小饼干

=LET(T,RIGHT(A2:A12,6)*1,_T,T-SEQUENCE(ROWS(T)),TEXTJOIN("\",TRUE,REDUCE("",UNIQUE(_T),LAMBDA(X,Y,LET(_X,FILTER(T,_T=Y),VSTACK(X,"XLI"&TAKE(_X,1)&"-"&RIGHT(TAKE(_X,-1),2)))))))

博爱风雨同舟

=LET(S,TEXTAFTER(A2:A12,"XLI")/1,TEXTJOIN("/",,"XLI"&TAKE(GROUPBY(SORT(S)-ROW(2:12),SORT(S),LAMBDA(X,@X&IF(ROWS(X)=1,,-MAX(X))),,0),,-1)))

leepoison

=LET(b,SORT(A2:A12),c,RIGHT(b,2),TEXTJOIN("/",,"XLI2512"&BYROW(DROP(GROUPBY(c-ROW(A2:A12),c,LAMBDA(x,TEXTJOIN("-",,TAKE(x,{1,-1})))),-1,1),LAMBDA(y,IF(EVALUATE(y)=0,TEXTBEFORE(y,"-"),y)))))