|
发表于 2013-3-8 11:46
|
显示全部楼层
本楼为最佳答案
本帖最后由 爱疯 于 2013-3-8 13:56 编辑
- Sub ye()
- Dim Ar(1), D As New Dictionary, I&
- Ar(0) = Range([k2], [k2].End(4)).Value
- Ar(1) = Range([i2], [i2].End(4)).Value
- For I = 1 To UBound(Ar(0))
- D(Ar(0)(I, 1)) = D(Ar(0)(I, 1)) + 1
- Next I
- For I = 1 To UBound(Ar(1))
- If D.Exists(Ar(1)(I, 1)) Then
- D(Ar(1)(I, 1)) = D(Ar(1)(I, 1)) - 1
- If D(Ar(1)(I, 1)) < 3 Then D.Remove Ar(1)(I, 1)
- End If
- Next I
- If D.Count > 0 Then [a1].Resize(D.Count) = Application.Transpose(D.Keys)
- End Sub
复制代码
Book2.xls4.rar
(10 KB, 下载次数: 3)
|
评分
-
查看全部评分
|