|
去除重复,只留一个就行
- Sub demo()
- Dim arr, i%, n%, d1, d2, dic As Object
- Set dic = CreateObject("Scripting.Dictionary")
- With ThisWorkbook
- arr = .Sheets(2).Range("A1").CurrentRegion
- d1 = .Sheets(1).[I1]
- d2 = .Sheets(1).[K1]
- For i = LBound(arr) + 1 To UBound(arr)
- If arr(i, 2) >= d1 And arr(i, 2) <= d2 And arr(i, 8) <> "本货站" And (arr(i, 10) = "厂家A" Or arr(i, 10) = "厂家B") Then
- dic(arr(i, 8)) = ""
- End If
- Next
- .Sheets(1).Range("A1:F1").ClearContents '清除A1:F1内容
- .Sheets(1).Range("A1").Resize(1, dic.Count) = dic.keys
- End With
- End Sub
复制代码
|
|