求大佬指教

z55660701 · 发表于 2024-10-13 12:36

怎么从A、B、C下面数组各抽取一个数相加，并且遍历出每种组合的结果，结果重复的去掉，并且从小到大排列

leepoison · 发表于 2024-10-13 13:50

=ARRAYTOTEXT(UNIQUE(TOCOL(TOCOL(1*TOCOL(REGEXP(D4,"\d+"))+1*REGEXP(F4,"\d+"))+1*REGEXP(H4,"\d+"))))

mykitami · 发表于 2024-10-13 15:16

=LET(a,TEXTSPLIT(D4,,",",1),b,TEXTSPLIT(F4,",",,1),c,TEXTSPLIT(H4,",",,1),UNIQUE(TOCOL(TOCOL(a+b)+c)))

你是那块小饼干 · 发表于 2024-10-13 16:01

=UNIQUE(DROP(LET(A,TEXTSPLIT(D4,,",",1),B,TEXTSPLIT(F4,,",",1),C,TEXTSPLIT(H4,,",",1),REDUCE("",A,LAMBDA(X,Y,VSTACK(X,TOCOL(EVALUATE((Y&"+"&B)&"+"&TRANSPOSE(C))))))),1)*1)

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

[求助] 求大佬指教