提取多个单元格内相同姓名

放逐草原

=TEXTJOIN(",",1,IF(ISNUMBER(FIND(TRIM(MID(SUBSTITUTE(E6,"，",REPT(" ",10)),1+10*(ROW($1:$10)-1),10)),E7)),TRIM(MID(SUBSTITUTE(E6,"，",REPT(" ",10)),1+10*(ROW($1:$10)-1),10)),""))

数组三键

老牛史潤生

=TEXTJOIN(",",1,IF(ISNUMBER(FIND(TRIM(MID(SUBSTITUTE(E6,"，",REPT(" ",10)),1+10*(ROW($1:$10)-1),10)),E7)),TRIM(MID(SUBSTITUTE(E6,"，",REPT(" ",10)),1+10*(ROW($1:$10)-1),10)),""))

数组三键

识者

不好意思，测试后无法使用

电脑计算机监控

不好意思，测试后无法使用

星空的云

=TEXTJOIN("，",,LET(x,FILTERXML("<a><b>"&SUBSTITUTE(E6,"，","</b><b>")&"</b></a>","//b"),REPT(x,ISNUMBER(FIND(x,E7)))))