|
- Sub tt()
- Application.ScreenUpdating = False
- Application.Interactive = False
- Dim i&, dic As Object, arr1
- Set dic = CreateObject("scripting.dictionary")
- With Sheet1
- arr1 = .Cells(1, "a").Resize(.Cells(Rows.Count, "a").End(3).Row - 1, 2).Value
- Debug.Print UBound(arr1)
- For i = 1 To UBound(arr1)
- dic(arr1(i, 1)) = dic(arr1(i, 1)) + 1
- Next
- For i = 1 To UBound(arr1)
- arr1(i, 2) = dic(arr1(i, 1))
- Next
- .Cells(1, "a").Resize(UBound(arr1), 2) = arr1
- End With
- Dim m&, d As Object, arr2
- Set d = CreateObject("scripting.dictionary")
- With Sheet1
- arr2 = .Cells(1, "c").Resize(.Cells(Rows.Count, "c").End(3).Row - 1, 2).Value
- For m = 1 To UBound(arr2)
- d(arr2(m, 1)) = d(arr2(m, 1)) + 1
- Next
- For m = 1 To UBound(arr2)
- arr2(m, 2) = d(arr2(m, 1))
- Next
- .Cells(1, "c").Resize(UBound(arr2), 2) = arr2
- End With
- 'Dim x&
- 'For x = 1 To 65600
- 'Cells(x, "e") = Cells(x, "e") - 1
- 'Cells(x, "b") = Cells(x, "b") + Cells(x, "e")
- 'Cells(x, "f") = Cells(x, "f") - 1
- 'Cells(x, "d") = Cells(x, "d") + Cells(x, "f")
- 'Next
- Application.ScreenUpdating = True
- Application.Interactive = True
- End Sub
复制代码
|
|