|
发表于 2016-11-15 18:14
|
显示全部楼层
本楼为最佳答案
- Sub Macro13()
- Dim arr, d
- Set d = CreateObject("scripting.dictionary")
- Columns("N:ag").ClearContents
- arr = Range("a1").CurrentRegion
- For i = 1 To UBound(arr)
- n = 26
- For j = 1 To UBound(arr, 2)
- d(arr(i, j)) = d(arr(i, j)) + 1
- Next
- For Each a In d.keys
- If d(a) > 1 Then n = n + 1: Cells(i, n) = a
- Next
- d.RemoveAll
- Next
- End Sub
复制代码 前面加一句?不知道是不是这个意思 |
|