求教一个多条件合并单元格内容的公式

lk710618

如附件，我需要根据多个条件，将符合条件的单元格内容都合并到一个单元格去，烦请老师指点，谢谢

dambcer

有Filter和text join的版本

1. =TEXTJOIN("、",1,FILTER(表1[日]&"、"&表1[事项],(表1[年]=I10)*(表1[月]=J10)*(表1[本月
   
2. 重点]=1)))

复制代码

manageadmi

1. =LET(A,FILTER(E2:E1000,(A2:A1000=I10)*(B2:B1000=J10)*(G2:G1000=1)),TEXTJOIN("；",1,SEQUENCE(COUNTA(A))&"、"&A))

复制代码

free冬少

=TEXTJOIN("；",1,COLUMN(INDIRECT("A:"&CHAR(64+COUNTA(TEXTSPLIT(TEXTJOIN("；",1,IF(($A$2:$A$66=I10)*($B$2:$B$66=J10)*($G$2:$G$66<>""),$E$2:$E$66,"")),"；")))))&"、"&TEXTSPLIT(TEXTJOIN("；",1,IF(($A$2:$A$66=I10)*($B$2:$B$66=J10)*($G$2:$G$66<>""),$E$2:$E$66,"")),"；"))数组三键