|
本帖最后由 lijian8003 于 2015-3-4 12:46 编辑
请看附件。
如何在C列数据中,删除曾在A列 B列出现过的数据,并将结果写入D列
- Sub x()
- Dim ar, x, k, br(1 To 30000, 1 To 1)
- Range("d:d").ClearContents
- ar = Range("c1:c" & [c65500].End(3).Row)
- For x = 1 To UBound(ar)
- If Application.CountIf(Range("a:b"), ar(x, 1)) = 0 Then
- k = k + 1
- br(k, 1) = ar(x, 1)
- End If
- Next
- [d1].Resize(k) = br
- End Sub
复制代码
|
|