|
[广告] Excel易用宝 - 提升Excel的操作效率 · Excel / WPS表格插件 ★ 免费下载 ★ ★ 使用帮助★
比较通用的代码- Sub cc()
- Dim i&, j&, m&, n&, x&, ar1, ar2, s() As String, d As Object, dic As Object
- ar1 = Range([l1], [l65536].End(3))
- ar2 = Range([m1], [m65536].End(3))
- ReDim s(1 To UBound(ar1), 1 To 3)
- Set d = CreateObject("scripting.dictionary")
- Set dic = CreateObject("scripting.dictionary")
- For i = 1 To UBound(ar1)
- d(ar1(i, 1)) = ""
- Next
- For j = 1 To UBound(ar2)
- dic(ar2(j, 1)) = ""
- If Not d.Exists(ar2(j, 1)) Then
- m = m + 1
- s(m, 2) = ar2(j, 1)
- Else
- n = n + 1
- s(n, 3) = ar2(j, 1)
- End If
- Next
- For i = 1 To UBound(ar1)
- If Not dic.Exists(ar1(i, 1)) Then
- x = x + 1
- s(x, 1) = ar1(i, 1)
- End If
- Next
- Application.ScreenUpdating = False
- [n1:p1] = [{"L独有","M独有","LM共有"}]
- [n2].Resize(UBound(s), 3) = s
- Application.ScreenUpdating = True
- End Sub
复制代码 |
|