|
加上分列。- Sub ykcbf() '//2024.5.5
- Dim arr, brr, d
- Application.ScreenUpdating = False
- Set d = CreateObject("scripting.dictionary")
- With Sheets("Sheet1")
- r = .Cells(Rows.Count, 1).End(3).Row
- .Range("b:z") = ""
- arr = .[a1].Resize(r, 20)
- ReDim brr(1 To 10000, 1 To 2)
- For i = 2 To UBound(arr)
- st = arr(i, 1)
- b = Split(st)
- n = 1
- For x = 0 To UBound(b)
- s = b(x)
- arr(i, n + x + 1) = b(x)
- If Not d.Exists(s) Then
- M = M + 1
- d(s) = M
- brr(M, 1) = b(x)
- brr(M, 2) = 1
- Else
- k = d(s)
- brr(k, 2) = brr(k, 2) + 1
- End If
- Next
- .[a1].Resize(r, 20) = arr
- Next
- End With
- With Sheets("Sheet2")
- .UsedRange.Offset(1) = ""
- .Range("a2").Resize(M, 2) = brr
- End With
- Set d = Nothing
- Application.ScreenUpdating = True
- MsgBox "OK!"
- End Sub
复制代码
|
|