|
- Sub Macro1()
- Dim arr, d, i&, s1&, s2&, zf$
- Set d = CreateObject("scripting.dictionary")
- arr = Range("a1").CurrentRegion
- For i = 2 To UBound(arr)
- zf = Join(Application.Index(arr, i, 0), ",")
- d(zf) = d(zf) + 1
- Next
- s2 = 1: s1 = 1
- [a1:d1].Copy Sheet2.[a1]
- [a1:d1].Copy Sheet3.[a1]
- a = d.keys: b = d.items
- For i = 0 To d.Count - 1
- If b(i) = 1 Then
- s2 = s2 + 1
- Sheet3.Cells(s2, 1).Resize(1, 4) = Split(a(i), ",")
- Else
- s1 = s1 + 1
- Sheet2.Cells(s1, 1).Resize(1, 4) = Split(a(i), ",")
- End If
- Next
- End Sub
复制代码 |
|