怎么核对A列、B列数据是否有相同的值

知道的大神给个回复吧~~~让我这个小白感受下excel的强大吧

再给你来个图吧，测试了 结果还算可以

或者我把问题分成几个步骤，现在只要实现，A2=郭靖，B2=郭靖、黄蓉，检索B2是中包含A2的值。。。。大神，有这样的函数吗

再粘一次，度娘删回复。。
Sub 秋天()
Dim rng As Range, a$, arr(1 To 100), n%
Set regx = CreateObject("vbscript.regexp")
With regx
.Global = True
.Pattern = "[一-龥]+"
For Each rng In Range("a2", [a2].End(4))
For Each m In .Execute(rng)
rg = Replace(rng(1, 2), m, "")
If Len(m) = Len(rng(1, 2)) - Len(rg) And Len(m) > 1 Then
a = a & " " & m
End If
Next
n = n + 1
arr(n) = a
a = ""
Next
End With
[c2].Resize(n) = Application.Transpose(arr)
End Sub

2L删的回复当时也没问题，依然是不能有张仙和张仙女这样的比对即可。
Sub 秋天()
Dim rng As Range, rg As Range, a$, arr(1 To 100), n%
Set regx = CreateObject("vbscript.regexp")
With regx
.Global = True
.Pattern = "[一-龥]+"
For Each rng In Range("a2", [a2].End(4))
For Each m In .Execute(rng)
Set rg = rng(1, 2).Find(m)
If Not rg Is Nothing Then
a = a & " " & m
End If
Next
n = n + 1
arr(n) = a
a = ""
Next
End With
[c2].Resize(n) = Application.Transpose(arr)
End Sub

方法3 对A,B列进行顿号和空格分列。A列分成DEF,B列在HIJ列
=IF(COUNTIF(H2:J2,D2),D2&" ",)&IF(COUNTIF(H2:J2,E2),E2&" ",)&IF(COUNTIF(H2:J2,F2&" "),F2,)