|
- Option Explicit
- Sub liuts()
- Dim arr, i As Long, brr(1 To 50000, 1 To 3), sr$, j As Long, d As New Dictionary
- sr = Sheet1.[a2]
- arr = Sheet4.Range("A1").CurrentRegion.Value
- For i = 2 To UBound(arr)
- If arr(i, 1) = sr And arr(i, 5) <> "" Then
- j = j + 1
- If Not d.Exists(arr(i, 5)) Then
- d.Add arr(i, 5), arr(i, 4)
- brr(j, 1) = arr(i, 5): brr(j, 2) = arr(i, 5): brr(j, 3) = arr(i, 4)
- Else
- brr(j, 1) = arr(i, 5)
- End If
- End If
- Next i
- Sheet1.Range("b2").Resize(j, 3) = brr
- Columns("C:D").SpecialCells(xlCellTypeBlanks).Delete Shift:=xlUp
- End Sub
复制代码 |
|