|
发表于 2012-3-15 10:14
|
显示全部楼层
本楼为最佳答案
- Sub 提取()
- Dim d As New Dictionary
- Dim i As Integer, j As Integer, k As Integer, l As Integer
- Dim ar, br(1 To 1000, 1 To 2)
- ar = Range("d6:iq15")
- For i = 1 To UBound(ar)
- For j = 1 To UBound(ar, 2)
- d(ar(i, j)) = d(ar(i, j)) + 1
- Next j
- For k = 1 To d.Count
- If d.Items(k - 1) < 18 Or d.Items(k - 1) > 45 Then
- l = l + 1
- br(l, 1) = d.Items(k - 1) & "个"
- br(l, 2) = d.Keys(k - 1)
- End If
- Next k
- d.RemoveAll
- Next
- Range("a2:b65536").ClearContents
- If l > 0 Then
- Range("a2").Resize(l, 2) = br
- End If
- End Sub
复制代码 运行前,工具-引用-浏览-文件名输入scrrun.dll,打开-确定 |
|