自己做的都没用,
=COUNT(FIND(MID(J11,ROW(INDIRECT("1:"&LEN(J11))),1),I11))=len(I11)
=TEXTJOIN(,,IF(FREQUENCY(MATCH(MID(A2&B1,ROW(INDIRECT("1:"&LEN(A2&B1))),1),MID(A2&B1,ROW(INDIRECT("1:"&LEN(A2&B1))),1),),MATCH(MID(A2&B1,ROW(INDIRECT("1:"&LEN(A2&B1))),1),MID(A2&B1,ROW(INDIRECT("1:"&LEN(A2&B1))),1),))=1,MID(A2&B1,ROW(INDIRECT("1:"&LEN(A2&B1))),1),""))
求大神给个函数#Excel#
![](http://tiebapic.baidu.com/forum/w%3D580/sign=bc3e5a3bc144ebf86d716437e9f9d736/93ccb2fb43166d22981476ac002309f79052d25b.jpg?tbpicau=2024-09-19-05_214646c9d864ee74320a18503ab3bd44)
=COUNT(FIND(MID(J11,ROW(INDIRECT("1:"&LEN(J11))),1),I11))=len(I11)
=TEXTJOIN(,,IF(FREQUENCY(MATCH(MID(A2&B1,ROW(INDIRECT("1:"&LEN(A2&B1))),1),MID(A2&B1,ROW(INDIRECT("1:"&LEN(A2&B1))),1),),MATCH(MID(A2&B1,ROW(INDIRECT("1:"&LEN(A2&B1))),1),MID(A2&B1,ROW(INDIRECT("1:"&LEN(A2&B1))),1),))=1,MID(A2&B1,ROW(INDIRECT("1:"&LEN(A2&B1))),1),""))
求大神给个函数#Excel#
![](http://tiebapic.baidu.com/forum/w%3D580/sign=bc3e5a3bc144ebf86d716437e9f9d736/93ccb2fb43166d22981476ac002309f79052d25b.jpg?tbpicau=2024-09-19-05_214646c9d864ee74320a18503ab3bd44)