6,210
社区成员
发帖
与我相关
我的任务
分享
Sub Macro1()
Dim arr, brr, i As Long, j As Long, n As Long
arr = [a1].CurrentRegion
ReDim brr(1 To UBound(arr), 1 To 3)
For i = 1 To UBound(arr)
If arr(i, 1) <> temp Then
n = n + 1
brr(n, 1) = arr(i, 1)
brr(n, 2) = arr(i, 2)
brr(n, 3) = arr(i, 3)
temp = arr(i, 1)
Else
If InStr(brr(n, 3), arr(i, 3)) = 0 Then brr(n, 3) = brr(n, 3) & "," & arr(i, 3)
End If
Next
[e1].Resize(n, 3) = brr
MsgBox "Ok"
End Sub