|
借用2楼大师的代码,数据多时,可以提升下速度:- Sub test1()
- Dim arr, brr(), i%, j%, d, temp
- arr = Range("a1").CurrentRegion
- ReDim brr(1 To UBound(arr), 1 To UBound(arr, 2))
- ReDim re(1 To UBound(arr), 1 To UBound(arr, 2))
- Set d = CreateObject("scripting.dictionary")
- Range("M:Z").ClearContents
- For i = 1 To UBound(arr)
- For j = 1 To UBound(arr, 2)
- If arr(i, j) <> "" Then
- d(Right(arr(i, j), 1)) = d(Right(arr(i, j), 1)) + 1
- End If
- Next
- temp = d.items
- d.RemoveAll
- For j = 0 To UBound(temp)
- re(i, j + 1) = temp(j)
- Next j
- Next
- [m1].Resize(UBound(re), UBound(re, 2)) = re
- End Sub
复制代码 |
评分
-
查看全部评分
|