- Sub Macro1()
- Dim arr, brr, i&, j%, p$$, s%
- arr = Range("b17").CurrentRegion
- ReDim brr(1 To 10, 1 To UBound(arr, 2))
- For j = 1 To UBound(arr, 2)
- p = "": s = 0
- For i = UBound(arr) To 1 Step -1
- If InStr(p, arr(i, j)) = 0 Then
- s = s + 1
- brr(s, j) = arr(i, j)
- p = p & arr(i, j)
- End If
- Next
- Next
- Range("b52").Resize(10, UBound(brr, 2)) = brr
- End Sub
复制代码 |