|
求大神帮忙,将A列和B列的数据筛选出来,将A列和B列不重复的值按照A列排序到SHEET3,并且CDEFGH都随着A列移动到SHEET3,大神帮帮忙解决一下把
- Sub 提取()
- arr = Sheets(1).Range("a1:f" & Sheets(1).UsedRange.Rows.Count + 1)
- Set d = CreateObject("scripting.dictionary")
- For i = 3 To UBound(arr)
- For j = 1 To 2
- x = arr(i, j)
- If Len(x) > 0 Then d(x) = d(x) & "," & i
- Next
- Next
- ReDim brr(1 To UBound(arr), 1 To UBound(arr, 2))
- For Each x In d.keys
- i = Mid(d(x), 2)
- If InStr(i, ",") = 0 Then
- n = n + 1
- brr(n, 1) = x
- For j = 3 To UBound(arr, 2)
- brr(n, j) = arr(i, j)
- Next
- End If
- Next
- With Sheets(3)
- .Cells.ClearContents
- If n > 0 Then .[a1].Resize(n, UBound(brr, 2)) = brr
- End With
- End Sub
复制代码
|
|