原始表格中有31组数据,每组261个,需要将:原始表格-(动液面)列中的非0数据在对应井中依次罗列出来。如M19-6非0数据有两个:723,722;需在表格中按顺序罗列出来;希望能帮忙解决下,谢谢!
- Sub tt()
- arr = Sheet1.[a1].CurrentRegion
- Set d = CreateObject("scripting.dictionary")
- For i = 2 To UBound(arr)
- x = arr(i, 1)
- If arr(i, 14) > 0 Then d(x) = d(x) & arr(i, 14) & ","
- Next
- Application.ScreenUpdating = False
- With Sheet2
- .[b4].Resize(1000, 100).ClearContents
- arr = .Range("a1:a" & .[a65536].End(3).Row)
- For i = 2 To UBound(arr)
- x = arr(i, 1)
- If d.exists(x) Then
- xrr = Split(d(x), ",")
- .Cells(i, 2).Resize(1, UBound(xrr)) = xrr
- End If
- Next
- End With
- Application.ScreenUpdating = True
- End Sub
复制代码
|