本帖最后由 云影 于 2014-5-20 10:59 编辑
Sub test()
Dim arr, ar1, er(), d As Object, x&, i&, k%, n%
Set da = CreateObject("scripting.dictionary")
Set dc = CreateObject("scripting.dictionary")
Range("e:f").ClearContents
i = Cells.Find("*", , , , , xlPrevious).Row
arr = Range("a2:c" & i + 1).Value
ReDim er(1 To i + 1, 1 To 2)
For x = 1 To i
da(arr(x, 1)) = ""
dc(arr(x, 3)) = ""
Next
For x = 1 To i
If Not da.exists(arr(x, 3)) Then
k = k + 1
er(k + 1, 1) = arr(x, 3) '多的
End If
If Not dc.exists(arr(x, 1)) Then
n = n + 1
er(n + 1, 2) = arr(x, 1) '少的
End If
Next
er(1, 1) = "C比A列多": er(1, 2) = "C比A列少"
Range("E2").Resize(x, 2) = er
End Sub