|
学习一下字典,打扰了
单元格格式设置成文本
arr = [a1].CurrentRegion
Set d = CreateObject("scripting.dictionary")
For i = 2 To UBound(arr)
For j = 1 To Len(arr(i, 1))
s = Mid(arr(i, 1), j, 1)
d(s) = ""
Next
For k = 1 To Len(arr(i, 2))
s = Mid(arr(i, 2), k, 1)
If d.exists(s) Then
arr(i, 3) = arr(i, 3) & "," & s
End If
Next
d.RemoveAll
Next
For i = 2 To UBound(arr)
s = Mid(arr(i, 3), 2)
brr = Split(s, ",")
For j = 0 To UBound(brr)
For k = j + 1 To UBound(brr)
If brr(j) > brr(k) Then
t = brr(j): brr(j) = brr(k): brr(k) = t
End If
Next
Next
For l = 0 To UBound(brr)
s1 = s1 & brr(l)
Next
arr(i, 3) = s1
s1 = ""
Next
[a1].CurrentRegion = arr |
|