|
李建军 发表于 2014-10-14 12:13
那能来个vba 感受下! 感谢!!! - Sub demo()
- Dim arr, re(), m As String, str As String
- m = Range("j2")
- arr = Sheets("备用").Range("a2:g" & Sheets("备用").Cells(Rows.Count, 1).End(xlUp).Row)
- Set d = CreateObject("Scripting.Dictionary")
- ReDim re(1 To UBound(arr), 1 To 6)
- For i = 1 To UBound(arr)
- If arr(i, 2) = m Then
- str = arr(i, 4) & "|" & arr(i, 5)
- If Not d.Exists(str) Then
- Cnt = Cnt + 1
- d(str) = Cnt
- For j = 1 To 6
- re(Cnt, j) = arr(i, j)
- Next j
- End If
- End If
- Next i
- Sheets("备用").Range("j3").Resize(Cnt, 6) = re
- End Sub
复制代码 |
评分
-
查看全部评分
|