|
猜是这个意思
For hxh = 3 To Range("b1").CurrentRegion.Rows.Count
ReDim arr3(1 To 1)
arr1 = Split(Cells(hxh - 1, 2).Value, " ")
arr2 = Split(Cells(hxh, 2).Value, " ")
For lxh1 = LBound(arr1) To UBound(arr1)
For lxh2 = LBound(arr2) To UBound(arr2)
If arr1(lxh1) = arr2(lxh2) Then
n = n + 1
ReDim Preserve arr3(1 To n)
arr3(n) = arr1(lxh1)
Exit For
End If
Next lxh2
Next lxh1
If n >= 3 Then Cells(hxh, 3).Resize(1, n) = arr3
n = 0
Next hxh
End Sub
|
评分
-
查看全部评分
|