|
这容易:- Sub TQ()
- With Sheets("库存")
- .Range("B3:D65536").ClearContents
- Set dd = CreateObject("scripting.dictionary")
- arr = Sheets("入库表").Range("B3:D" & Sheets("入库表").Range("D65536").End(xlUp).Row)
- For x = 1 To UBound(arr)
- sr = arr(x, 1) & "-" & arr(x, 2)
- If Not dd.Exists(sr) Then
- dd(sr) = ""
- k = k + 1
- arr(k, 1) = arr(x, 1)
- arr(k, 2) = arr(x, 2)
- arr(k, 3) = arr(x, 3)
- End If
- Next x
- .Range("B3").Resize(k, 3) = arr
- .Range("B3:G10000").Sort Key1:=Range("B3"), Order1:=xlAscending
- End With
- End Sub
复制代码
提取多列不重复字段2.rar
(37.13 KB, 下载次数: 8)
|
|