|
[广告] Excel易用宝 - 提升Excel的操作效率 · Excel / WPS表格插件 ★ 免费下载 ★ ★ 使用帮助★
- Sub qq()
- Dim Arr, I%, j%, brr() As Byte, d, s$, x%, aa, zf$, crr, r%
- Set d = CreateObject("Scripting.Dictionary")
- Range("b2:c1000") = ""
- r = Cells(Rows.Count, 1).End(xlUp).Row
- Arr = Range("a1:c" & r)
- ReDim crr(1 To UBound(Arr), 1 To 1)
- For I = 2 To UBound(Arr)
- s = Replace(Arr(I, 1), " ", "")
- brr = s
- For j = 0 To UBound(brr) - 1
- For x = j + 1 To UBound(brr)
- If brr(j) > brr(x) Then aa = brr(j): brr(j) = brr(x): brr(x) = aa
- Next
- Next
- zf = brr: crr(I, 1) = zf
- d(crr(I, 1)) = d(crr(I, 1)) & "," & I
- Next
- For I = 2 To UBound(Arr)
- crr(I, 1) = d(crr(I, 1))
- aa = Split(crr(I, 1), ",")
- If UBound(aa) > 1 Then
- Arr(I, 2) = "重复": Arr(I, 3) = Arr(aa(1), 1)
- End If
- Next
- Range("a1:c" & r) = Arr
- End Sub
复制代码 |
评分
-
1
查看全部评分
-
|