|
发表于 2012-5-25 11:58
|
显示全部楼层
本楼为最佳答案
lkjpoi 发表于 2012-5-25 11:52
是这样,但重数不能用 = 2,我时常会变动数,用大于且小于通用强,一点小变动我也不懂. - Sub test()
- Dim ar, br, cr, dr(1 To 1000, 1 To 1)
- Dim i As Integer, j As Integer, k As Integer
- Dim d As Object
- Set d = CreateObject("scripting.dictionary")
- ar = Range("d11").CurrentRegion
- For j = 1 To UBound(ar, 2)
- If Cells(9, 3 + j) <> "" Then
- For i = 1 To UBound(ar)
- If ar(i, j) <> "" Then
- d(ar(i, j)) = d(ar(i, j)) + 1
- End If
- Next
- End If
- Next
- br = d.keys
- cr = d.items
- For i = 0 To UBound(cr)
- If cr(i) > 1 And cr(i) < 3 Then '这边改
- k = k + 1
- dr(k, 1) = br(i)
- End If
- Next
- Range("a11:a65536").Clear
- If k > 0 Then
- Range("a11").Resize(k, 1).NumberFormatLocal = "@"
- Range("a11").Resize(k, 1) = dr
- End If
- End Sub
复制代码
|
|