|
发表于 2014-2-12 20:58
|
显示全部楼层
本楼为最佳答案
- Sub t()
- Dim arr(), i&, j%, str$
- arr = Range("A1").CurrentRegion.Value
- For j = 1 To UBound(arr, 2)
- str = "'"
- For i = UBound(arr) To 1 Step -1
- If InStr(1, str, arr(i, j)) = 0 Then str = str & arr(i, j)
- If Len(str) = 7 Then Range("E110").Offset(0, j - 1) = str: Exit For
- Next
- Next
- End Sub
复制代码 |
|