Sub Click()
Dim A, d, i
Range("b:b").ClearContents
A = Range([a1], Cells(Rows.Count, 1).End(3))
Set d = CreateObject("scripting.dictionary")
For i = 1 To UBound(A)
d(A(i, 1)) = d(A(i, 1)) + 1
A(i, 1) = d(A(i, 1))
Next i
[b1].Resize(UBound(A)) = A
End Sub 1.rar(15.29 KB, 下载次数: 23)
Sub Click()
Dim A, d, i
Range("b:b").ClearContents
A = Range([a1], Cells(Rows.Count, 1).End(3))
Set d = CreateObject("scripting.dictionary")
For i = 1 To UBound(A)
d(A(i, 1)) = d(A(i, 1)) + 1
A(i, 1) = d(A(i, 1))
Next i
[b1].Resize(UBound(A)) = A
End Sub 1.rar(15.29 KB, 下载次数: 23)