查询唯一值

梦羽111

想请教各位老师，怎么样查询每天仓号去重复，保留唯一值。谢谢

我走我流

=TEXTJOIN("、",,UNIQUE(TOCOL(TRANSPOSE(FILTER(IF(LEN($C$6:$H$16)>1,$C$6:$H$16&$C$4:$H$4,""),$A$6:$A$16=$L5)))))

wdy895

先用PQ转换成1维表格，之后再用FILTER筛选就比较简单了。

leepoison

=TEXTJOIN("、",,FILTER(UNIQUE(TOCOL(FILTER($C$5:$H$15&REPTARRAY($C$4:$H$4,11),$A$5:$A$15=L5))),IFERROR(FIND("/",UNIQUE(TOCOL(FILTER($C$5:$H$15&REPTARRAY($C$4:$H$4,11),$A$5:$A$15=L5)))),0)=0))

mykitami

=LET(a,FILTER($C$6:$H$16,$A$6:$A$16=L5),TEXTJOIN("、",,UNIQUE(TOCOL(IF(a="/","",a&$C$4:$H$4),,1))))

你是那块小饼干

1. =TEXTJOIN(",",TRUE,LET(T,SUBSTITUTE(VSTACK(C4:H4,FILTER(C4:H16,A4:A16=L5,"")),"/",""),
   
2. REDUCE("",A19:A24,LAMBDA(X,Y,LET(_T,UNIQUE(CHOOSECOLS(T,Y)),
   
3. _X,TAKE(_T,1),_Y,TEXTSPLIT(TEXTJOIN(",",TRUE,DROP(_T,1)),",",,TRUE),IFNA(VSTACK(X,_Y&_X
   
4. ),""))))))
   

复制代码

你是那块小饼干

1. =TEXTJOIN(",",TRUE,LET(T,SUBSTITUTE(VSTACK(C4:H4,FILTER(C4:H16,A4:A16=L5,"")),"/",""),
   
2. REDUCE("",A19:A24,LAMBDA(X,Y,LET(_T,UNIQUE(CHOOSECOLS(T,Y)),
   
3. _X,TAKE(_T,1),_Y,TEXTSPLIT(TEXTJOIN(",",TRUE,DROP(_T,1)),",",,TRUE),IFNA(VSTACK(X,_Y&_X
   
4. ),""))))))
   

复制代码