试试!{:112:}
- Sub tq()
- Dim d As Object
- Dim ar, br(1 To 10000, 1 To 3)
- Dim i As Long, j As Long
- Set d = CreateObject("scripting.dictionary")
- ar = Sheets("数据源").Cells(1, 1).CurrentRegion
- For i = 2 To UBound(ar)
- If ar(i, 15) > 0 Then
- If Not d.exists(ar(i, 19)) Then
- d.Add ar(i, 19), ""
- j = j + 1
- br(j, 1) = "'" & Format(ar(i, 1), "000000")
- br(j, 2) = ar(i, 2)
- br(j, 3) = ar(i, 19)
- End If
- End If
- Next i
- With Sheets("结果表").Cells(2, 1)
- .Resize(Rows.Count - 1, 3).ClearContents
- .Resize(j, 3) = br
- End With
- End Sub
复制代码
|