A排除B中的数据，谢谢

mykitami

=CONCAT(TEXTSPLIT(A1,,MID(B1,SEQUENCE(LEN(B1)),1),1))

mykitami

=REDUCE(A1,MID(B1,SEQUENCE(LEN(B1)),1),LAMBDA(x,y,SUBSTITUTE(x,y,)))

华尔街操盘手

（上面有老师写了，没注意，请忽略）c1下拉

1. =REDUCE(A1,MID(B1,SEQUENCE(LEN(B1)),1),LAMBDA(x,y,SUBSTITUTE(x,y,"")))

复制代码

象山海鲜

1. =CONCAT(MID(A1,ROW($1:$10),ISERR(FIND(MID(A1,ROW($1:$10),1),B1))))

复制代码

1. =MID(NPV(-0.9,,IF(ISERR(FIND(MID(A1,11-ROW($1:$10),1),B1)),--MID(A1,11-ROW($1:$10),1)),1)%,2,10)

复制代码

niko88819

C1 公式下拉 ,   =nk(A1,B1)

1. Function nk(A As Long, B As Long) As Long
   
2.     Dim strA As String
   
3.     Dim strB As String
   
4.     Dim result As String
   
5.     Dim i As Integer
   
6.     strA = CStr(A)
   
7.     strB = CStr(B)
   
8.     For i = 1 To Len(strA)
   
9.         If InStr(strB, Mid(strA, i, 1)) = 0 Then
   
10.             result = result & Mid(strA, i, 1)
    
11.         End If
    
12.     Next i
    
13.     If result = "" Then
    
14.         nk = 0
    
15.     Else
    
16.         nk = CLng(result)
    
17.     End If
    
18. End Function

复制代码

你是那块小饼干

1. =REDUCE(A1,MID(B1,SEQUENCE(LEN(B1)),1),LAMBDA(X,Y,SUBSTITUTE(X,Y,"")))

复制代码

niko88819

D1

1. =MAP(A1:A8,B1:B8,LAMBDA(x,y,CONCAT(TEXTSPLIT(x,,MID(y,SEQUENCE(LEN(y)),1),1))))

复制代码

wlc5201130

=CONCAT(IF(LEN(A1&B1)-LEN(SUBSTITUTE(A1&B1,MID(A1,ROW($1:$8),1),))=1,MID(A1,ROW($1:$8),1),""))

inrever

1. =MAP(A1:A8,B1:B8,LAMBDA(x,y,SUBSTITUTES(x,REGEXP(y,"\d"),"")))

复制代码

wgreen

=TEXTJOIN(,TRUE,TEXTSPLIT(MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1),MID(B1,ROW(INDIRECT("1:"&LEN(B1))),1)))