|
发表于 2015-3-31 02:24
|
显示全部楼层
本楼为最佳答案
- Function cf(rg As Range, tj As Integer) '1 代表重复,2代表替换
- '=cf(单元格,1) =cf(单元格,2)
- Dim x, d, s, st, st1
- Set d = CreateObject("scripting.dictionary")
- st1 = rg
- For x = 1 To Len(rg)
- st = Mid(rg, x, 1)
- If d.exists(st) Then
- st1 = Replace(st1, st, "")
- If InStr(s, st) = 0 Then s = s & st
- Else
- d(st) = ""
- End If
- Next
- cf = IIf(tj = 1, s & "", IIf(tj = 2, st1, ""))
- End Function
复制代码 |
|