|
- Sub Ee()
- If Range("a1") = "" Then
- MsgBox "无数据可处理。"
- Exit Sub
- End If
- Dim d As Object, Hx&, Arr
- Set d = CreateObject("Scripting.Dictionary")
- Hx = Range("E200000").End(xlUp).Row
- Arr = Range("E2:E" & Hx).Value '将A列的内容放进数组
- For Hx = 1 To UBound(Arr)
- d(Arr(Hx, 1)) = "" '将A列的内容添加到字典
- Next
- Hx = Range("F200000").End(xlUp).Row
- Arr = Range("F2:F" & Hx).Value '将E列的内容放进数组
- For Hx = 1 To UBound(Arr) '如果E列的内容在字典中存在,就删除该值,否则添加该值
- If d.Exists(Arr(Hx, 1)) Then d.Remove (Arr(Hx, 1)) Else d(Arr(Hx, 1)) = ""
- Next
- [g2].Resize([a200000].End(1).Row, 1).ClearContents
- Range("G2").Resize(d.Count, 1) = Application.Transpose(d.keys)
- End Sub
复制代码
- Sub Ee()
- If Range("a1") = "" Then
- MsgBox "无数据可处理。"
- Exit Sub
- End If
- Dim d As Object, Hx&, Arr
- Set d = CreateObject("Scripting.Dictionary")
- Hx = Range("E200000").End(xlUp).Row
- Arr = Range("D2:E" & Hx).Value '将A列的内容放进数组
- For Hx = 1 To UBound(Arr)
- d(Arr(Hx, 2)) = "" '将A列的内容添加到字典
- Next
- Hx = Range("F200000").End(xlUp).Row
- Arr = Range("E2:F" & Hx).Value '将E列的内容放进数组
- For Hx = 1 To UBound(Arr) '如果E列的内容在字典中存在,就删除该值,否则添加该值
- If d.Exists(Arr(Hx, 2)) Then d.Remove (Arr(Hx, 2)) Else d(Arr(Hx, 2)) = ""
- Next
- [g2].Resize([a200000].End(1).Row, 1).ClearContents
- If d.Count > 0 Then Range("G2").Resize(d.Count, 1) = Application.Transpose(d.keys)
- End Sub
复制代码
|
|