|
发表于 2015-10-13 13:06
|
显示全部楼层
本楼为最佳答案
- Sub 核对()
- Dim d As Object, arr, brr(), i&, x&
- arr = [a1].CurrentRegion
- x = UBound(arr)
- ReDim brr(1 To x, 1 To 1)
- Set d = CreateObject("Scripting.Dictionary")
- For i = 2 To x
- d(arr(i, 1)) = ""
- Next
- For i = 2 To x
- If arr(i, 2) = "" Then Exit For
- If d.exists(arr(i, 2)) Then brr(i, 1) = "相符" Else brr(i, 1) = "无"
- Next
- brr(1, 1) = "核对结果"
- Range("c2:c" & x).Clear
- Range("c1").Resize(x) = brr
- End Sub
复制代码
核对结果.rar
(12.46 KB, 下载次数: 15)
|
评分
-
查看全部评分
|