|
楼主 |
发表于 2017-3-19 10:00
|
显示全部楼层
提取不重数据(修改原代码)
http://club.excelhome.net/thread-1334920-1-1.html
(- Sub tttt()
- Dim i%, k%, arr, brr, crr
- Dim d As Object
- Set d = CreateObject("scripting.dictionary")
- arr = Sheet1.Range("A1:at" & Sheet1.Range("a1048576").End(xlUp).Row)
- For i = 2 To UBound(arr)
- d(arr(i, 1) & "-" & arr(i, 2) & "-" & arr(i, 6) & "-" & arr(i, 46)) = ""
- Next
- brr = Application.Transpose(d.keys)
- ReDim crr(1 To UBound(brr), 1 To 4)
- For k = 1 To d.Count
- crr(k, 1) = Split(brr(k, 1), "-")(0)
- crr(k, 2) = Split(brr(k, 1), "-")(1)
- crr(k, 3) = Split(brr(k, 1), "-")(2)
- crr(k, 4) = Split(brr(k, 1), "-")(3)
- Next
- With Sheet2
- .Columns(1).NumberFormatLocal = "@"
- .[a1:d1] = Array("凭证序号", "纳税人名称", "二维表列序号", "行业")
- .[a2].Resize(UBound(crr), 4) = crr
- End With
- End Sub
复制代码
出处: ExcelHome技术论坛) |
|