- Sub lqh()
- Dim arr, d
- Set d = CreateObject("scripting.dictionary")
- arr = [a1].CurrentRegion
- For i = 1 To UBound(arr)
- If Not d.exists(arr(i, 1) & "|" & arr(i, 3) & "|" & arr(i, 4)) Then
- d(arr(i, 1) & "|" & arr(i, 3) & "|" & arr(i, 4)) = _
- arr(i, 1) & "|" & arr(i, 2) & "|" & arr(i, 3) & "|" & arr(i, 4) & "|" & arr(i, 5)
- End If
- Next i
- t = d.items: ReDim arr(1 To d.Count, 1 To 5)
- For i = 0 To UBound(t)
- For j = 0 To 4
- arr(i + 1, j + 1) = Split(t(i), "|")(j)
- Next j
- Next i
- Cells.Clear: [a1].Resize(UBound(arr), UBound(arr, 2)) = arr
- End Sub
复制代码 |