|
- Sub tt() '提取字符串中不重复值,并排序
- Set d = CreateObject("scripting.dictionary")
- arr = Range("b1:c" & [b65536].End(3).Row)
- For i = 2 To UBound(arr)
- xrr = Split(arr(i, 1), ",")
- For k = 0 To UBound(xrr)
- d(xrr(k)) = ""
- Next
- arr(i, 2) = Join(d.keys, ",")
- If arr(i, 1) <> arr(i, 2) Then
- [h1].Resize(d.Count, 1) = Application.Transpose(d.keys)
- [h1].Resize(d.Count, 1).Sort key1:=[h1]
- arr(i, 2) = Join(Application.Transpose([h1].Resize(d.Count, 1)), ",")
- End If
- d.RemoveAll
- Next
- [h:h].ClearContents
- [b1].Resize(UBound(arr), 2) = arr
- End Sub
复制代码 |
|