|
发表于 2013-9-21 14:19
|
显示全部楼层
本楼为最佳答案
- Sub abc()
- Set d = CreateObject("scripting.dictionary")
- Dim pp(1 To 100000, 1 To 3) As String
- kk = Range("g12:i28").Value
- For i = 1 To UBound(kk)
- If Not d.exists(kk(i, 1) & kk(i, 2) & kk(i, 3)) Then
- d(kk(i, 1) & kk(i, 2) & kk(i, 3)) = ""
- pp(x + 1, 1) = kk(i, 1)
- pp(x + 1, 2) = kk(i, 2)
- pp(x + 1, 3) = kk(i, 3)
- x = x + 1
- End If
- Next i
- Range("j12").Resize(d.Count, 3) = pp
- End Sub
复制代码 |
|