|
发表于 2016-7-28 12:02
|
显示全部楼层
本楼为最佳答案
- Sub xx()
- Dim i%, dA, dB, n&, k&
- Set dA = CreateObject("Scripting.Dictionary")
- Set dB = CreateObject("Scripting.Dictionary")
- With Sheet1
- n = .Cells(.Rows.Count, 6).End(xlUp).Row
- k = .Cells(.Rows.Count, 8).End(xlUp).Row
- For i = 5 To n
- If Not dA.Exists(.Cells(i, 6).Value) Then
- dA.Add .Cells(i, 6).Value, 1
- Else
- dA(.Cells(i, 6).Value) = dA(.Cells(i, 6).Value) + 1
- End If
- Next
- For i = 5 To k
- If Not dB.Exists(.Cells(i, 8).Value) Then
- dB(.Cells(i, 8).Value) = 1
- Else
- dB(.Cells(i, 8).Value) = dB(.Cells(i, 8).Value) + 1
- End If
- Next
- i = 0
- For Each ke In dA.Keys
- If dA(ke) < dB(ke) - 4 Then
- i = i + 1
- .Cells(i, 1) = ke
- End If
- Next
- End With
- End Sub
复制代码 |
|