排班提取

世界客都

排班提取.zip (12.24 KB, 下载次数: 29)

2024-6-2 22:28 上传

点击文件名下载附件

题目比较容易，期待各位老师的高招。

魚。。

东东主题，参与一下：

1. =LET(虾,TAKE(D2:D102,A2),魚,VSTACK(虾,虾),TEXTJOIN(",",,SORT(MAP(虾,LAMBDA(x,IF(AND(CHOOSEROWS(魚,MATCH(x,DROP(魚,1),)+{0,2})>=C2),x,""))))))

复制代码

windshc

=TEXTJOIN(",",1,REDUCE("",SEQUENCE(A2/2),LAMBDA(x,y,LET(a,INDIRECT("d2:d"&A2+1),b,MATCH(y,a,0),c,IF(b=A2,INDEX(a,1),INDEX(a,b+1)),d,IF(b=1,INDEX(a,A2),INDEX(a,b-1)),e,IF(AND(c>A2/2,d>A2/2),y,""),f,VSTACK(x,e),f))))

windshc

windshc

=TEXTJOIN(",",1,REDUCE("",SEQUENCE(A2/2),LAMBDA(x,y,LET(a,INDIRECT("d2:d"&A2+1),b,MATCH(y,a,0),c,IF(b=A2,INDEX(a,1),INDEX(a,b+1)),d,IF(b=1,INDEX(a,A2),INDEX(a,b-1)),e,IF(AND(c>A2/2,d>A2/2),y,""),f,VSTACK(x,e),f))))

丢丢表格

1. =TEXTJOIN(",",1,IFNA(SORT(IF(MMULT(N(N(OFFSET(D1,MOD(SEQUENCE(A2)-{2,0},A2)+1,))>=C2),{1;1})=2,D2:D106,"")),""))

复制代码

世界客都

大家这么晚都还没睡啊

tchh666

1. =TEXTJOIN(",",1,SORT(BYROW(INDEX(TOCOL(D2:D102*{1,1},2,1),SEQUENCE(A2)+{0,1,2}),LAMBDA(x,IF(AND(COUNTIF(B:B,x)={0,1,0}),INDEX(x,2),"")))))

复制代码

1. =TEXTJOIN(",",1,SORT(MAP(D2:D103,LAMBDA(X,LET(S,TAKE(D105:X,3),IF(AND(N(IF(S="",D2,S)<C2)={0;1;0}),INDEX(S,2),""))))))

复制代码

这个公式，WPS  需要 数组三键才能显示结果