求求大神来看看，无限感激

晓欣

求问各位大神以下公式：
=LET(g,CHAR(10),r,COUNTIFS(A2,底表!M$2:M$13,B2,底表!F$2:F$13),f,LAMBDA(m,n,LET(s,UNIQUE(FILTER(m,r)),TEXTJOIN(g,,SEQUENCE(ROWS(s))&n&":"&s))),f(底表!O$2:O$13,"装")&g&f(底表!AD$2:AD$13,"卸"))


忘记考虑安装装卸的顺序（1、2、3、4...）排序
最终第二个表装卸的显示顺序要根据第一个表的装卸顺序排序，能否再帮忙修改下下~~膜拜~

zwzc

直接修改

=LET(g,CHAR(10),r,COUNTIFS(A2,底表!M$2:M$13,B2,底表!F$2:F$13),f,LAMBDA(m,n,LET(s,UNIQUE(SORTBY(FILTER(m,r),FILTER(底表!$G$2:$G$13,r))),TEXTJOIN(g,,SEQUENCE(ROWS(s))&n&":"&s))),ff,LAMBDA(mm,nn,LET(s,UNIQUE(SORTBY(FILTER(mm,r),FILTER(底表!$H$2:$H$13,r))),TEXTJOIN(g,,SEQUENCE(ROWS(s))&nn&":"&s))),f(底表!O$2:O$13,"装")&g&ff(底表!AD$2:AD$13,"卸"))

晓欣

zwzc 发表于 2024-11-13 16:55
直接修改

=LET(g,CHAR(10),r,COUNTIFS(A2,底表!M$2:M$13,B2,底表!F$2:F$13),f,LAMBDA(m,n,LET(s,UNIQUE( ...

可以了 谢谢大神！~~

我要成为专家

1. =LET(s,FILTER(HSTACK(底表!O:O,底表!AD:AD),(底表!F:F=B2)*(底表!M:M=A2)),k,UNIQUE(TAKE(s,,-1)),p,UNIQUE(TAKE(s,,1)),TEXTJOIN(CHAR(10),,VSTACK(SEQUENCE(ROWS(p))&"装："&p,SEQUENCE(ROWS(k))&"卸："&k)))

复制代码

你是那块小饼干

1. =LET(T,F2:F13,_T,UNIQUE(T),REDUCE({"日期","车次","发车信息(例子)"},_T,LAMBDA(X,Y,LET(
   
2. _装,SORT(FILTER(HSTACK(G2:G13,O2:O13),Y=T,"")),_装1,UNIQUE(INDEX(_装,,2)),_装2,SEQUENCE(ROWS(_装1))&"装:"&_装1,
   
3. _卸,SORT(FILTER(HSTACK(H2:H13,AD2:AD13),Y=T,"")),_卸1,UNIQUE(INDEX(_卸,,2)),_卸2,SEQUENCE(ROWS(_卸1))&"卸:"&_卸1,VSTACK(X,HSTACK(SUBSTITUTE(XLOOKUP(Y,F2:F13,E2:E13),Y,""),Y,TEXTJOIN(CHAR(10),TRUE,_装2,_卸2)))))))
   

复制代码