根据基础数据，按要求查找显示对应数据

放长线钓大鱼

如何实现 姓名和工作时间分行显示，工作量和工作类别对应显示。

zwzc

=LET(f,LAMBDA(x,TOCOL(IF(C2:F7<>"",x,a),3)),HSTACK(SEQUENCE(COUNTA(C2:F7)),f(B2:B7),f(C2:F7),f(G2:G7),f(H2:H7)))

放长线钓大鱼

zwzc 发表于 2025-3-31 15:49
=LET(f,LAMBDA(x,TOCOL(IF(C2:F7"",x,a),3)),HSTACK(SEQUENCE(COUNTA(C2:F7)),f(B2:B7),f(C2:F7),f(G2:G7), ...

牛叉，，谢谢大神

hugeinfo

=LET(d,DROP(REDUCE("",B2:B7,LAMBDA(x,y,VSTACK(x,LET(a,LAMBDA(b,TOCOL(IF(OFFSET(y,,1,,4)<>"",b,z),3)),c,HSTACK(a(y),a(OFFSET(y,,1,,4))),HSTACK(c,IF(SEQUENCE(ROWS(c)),OFFSET(y,,5,,2))))))),1),HSTACK(SEQUENCE(ROWS(d)),d))

hxj119

1. =LET(f,LAMBDA(x,TOCOL(IF(C2:F7<>"",x,Y),3)),HSTACK(f(B2:B7),f(C2:F7),f(G2:G7),f(H2:H7)))

复制代码

mengrs

=LET(a,DROP(REDUCE(0,B2:B6,LAMBDA(x,y,VSTACK(x,IF({1,0},y,TOCOL(OFFSET(y,,1,,4),1))))),1),SORTBY(a,MATCH(TAKE(a,,1),{"张三";"李四";"王麻子"},)))

放长线钓大鱼

hugeinfo 发表于 2025-3-31 15:51
=LET(d,DROP(REDUCE("",B2:B7,LAMBDA(x,y,VSTACK(x,LET(a,LAMBDA(b,TOCOL(IF(OFFSET(y,,1,,4)"",b,z),3)),c ...

谢谢大神，

飞天篮球猪

仅供参考...

秃头发师

=DROP(REDUCE("",B2:B7,LAMBDA(x,y,VSTACK(x,HSTACK(EXPAND(y,COUNTA(OFFSET(y,,1,,4)),,y),TOCOL(OFFSET(y,,1,,4),3),CHOOSE(SEQUENCE(COUNTA(OFFSET(y,,1,,4)),,1,0),OFFSET(y,,5,,2)))))),1)

快乐王子238

手机盲打
=let(数据区域,c2:h7,fx,lambda(x,Tocol(if(数据区域<>"",x,0/0),3)),arr,hstack(fx(b2:b7),fx(c2:c7),fx(数据区域),fx(g2:g7),fx(h2:h7)),vstack({"序号","姓名","工作时间","工作量","工作类别"},hstack(seuqence(rows(arr)),arr))