|
发表于 2012-2-2 15:34
|
显示全部楼层
本楼为最佳答案
- Sub justtest()
- Dim d As New Dictionary, Arr(1 To 2), i&, j As Byte, Ar
- Arr(1) = Range("c5:c" & Cells(Rows.Count, 3).End(3).Row).Value
- Arr(2) = Range("d5:d" & Cells(Rows.Count, 3).End(3).Row).Value
- For j = 1 To 2
- For i = 1 To UBound(Arr(j))
- d(Arr(j)(i, 1)) = d(Arr(j)(i, 1)) + 1
- Next i, j
- Ar = d.Keys
- For i = 0 To UBound(Ar)
- If d(Ar(i)) < 2 Or d(Ar(i)) > 5 Then
- d.Remove Ar(i)
- End If
- Next i
- Range("h20:h" & Rows.Count).ClearContents
- If d.Count > 0 Then Range("h20").Resize(d.Count) = Application.Transpose(d.Keys)
- Set d = Nothing
- End Sub
复制代码
Book2b.rar
(13.03 KB, 下载次数: 10)
|
|