请教老师，用公式联动两个表格的数字，自动生成，谢谢！

cartel · 发表于 2024-11-19 20:38

无关岁月 · 发表于 2024-11-19 20:54

=TEXTJOIN(",",,FILTER(VSTACK(0,Sheet1!C1:C161),BYROW(--REGEXP(AH50,"[^,]+")=VSTACK(0,Sheet1!D1:D161),OR)))

复制代码

博爱风雨同舟 · 发表于 2024-11-19 22:18

=GROUPBY(Sheet1!D1:D161,Sheet1!C1:C161,ARRAYTOTEXT,,0,,LET(S,--TEXTSPLIT(AH50,,","),MMULT(--(Sheet1!D1:D161=TRANSPOSE(S)),SEQUENCE(COUNT(S))^0)))

你是那块小饼干 · 发表于 2024-11-20 08:01

=REDUCE("",TEXTSPLIT(H1,,",",TRUE)*1,LAMBDA(X,Y,TEXTJOIN(",",TRUE,VSTACK(X,FILTER(C1:C161,Y=D1:D161,0)))))

mykitami · 发表于 2024-11-20 09:04

=TEXTJOIN(",",1,DROP(REDUCE("",--TEXTSPLIT(AH50,,",",1),LAMBDA(x,y,VSTACK(x,FILTER(Sheet1!C1:C161,Sheet1!D1:D161=y,0)))),1))

leepoison · 发表于 2024-11-20 09:19

=TEXTJOIN(",",1,MAP(1*REGEXP(AH50,"\d+"),LAMBDA(x,TEXTJOIN(",",1,IFERROR(FILTER(Sheet1!C1:C161,Sheet1!D1:D161=x),0)))))

hugeinfo · 发表于 2024-11-20 09:20

=TEXTJOIN(",",,FILTER(VSTACK(0,Sheet1!C1:C161),BYROW(VSTACK(0,Sheet1!D1:D161)=--TEXTSPLIT(AH50,",",),LAMBDA(a,SUM(a*1)))))

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

[求助] 请教老师，用公式联动两个表格的数字，自动生成，谢谢！