|
- Sub 数据整理()
- Dim arr, brr, i&, d, x, t, aa, j&
- arr = Range("a1:b" & Cells(Rows.Count, 1).End(xlUp).Row)
- ReDim brr(1 To UBound(arr), 1 To 1)
- Set d = CreateObject("scripting.dictionary")
- For i = 2 To UBound(arr)
- x = arr(i, 1)
- If Not d.exists(x) Then
- t = t & i & ","
- d(x) = arr(i, 2)
- Else
- d(x) = d(x) & arr(i, 2)
- End If
- Next
- t = Left(t, Len(t) - 1)
- aa = Split(t, ",")
- For j = 0 To UBound(aa)
- x = Val(aa(j))
- brr(x, 1) = d(arr(x, 1))
- Next
- [c:c].ClearContents
- [c1].Resize(UBound(arr), 1) = brr
- End Sub
复制代码 |
|