|
发表于 2014-3-31 13:14
|
显示全部楼层
本楼为最佳答案
- Sub Macro1()
- Dim arr, brr(1 To 10, 1 To 3), w(1 To 3)
- Dim i%, j&, s%
- x = [c210]
- arr = [c10:c210]
- For i = 1 To Len(x)
- w(i) = Mid(x, i, 1)
- Next
- For i = 1 To 3
- s = 0
- For j = UBound(arr) - 1 To 1 Step -1
- If Mid(arr(j, 1), i, 1) = w(i) Then
- s = s + 1
- If s > 10 Then Exit For Else brr(s, i) = arr(j + 1, 1)
- End If
- Next
- Next
- [d11:f20].NumberFormatLocal = "000"
- [d11:f20] = brr
- End Sub
复制代码 |
|