|
- Sub test31()
- Dim d As Object, A(), B(), i%, j%, s%, c%, n%
- With Sheet2
- Set d = CreateObject("scripting.dictionary")
- A = .Range("A1").CurrentRegion.Value
- n = 2
- ReDim B(1 To UBound(A) - n, 1 To 13)
- End With
- s = n
- For i = 2 To UBound(A)
- c = (Day(A(i, 2)) + 4) \ 5
- c = IIf(c > 6, 12, 2 * c) '日期的列
- If d.Exists(A(i, 1)) = False Then s = s + 1: d(A(i, 1)) = s
- B(s - n, 1) = A(i, 1)
- B(s - n, c) = A(i, 2)
- B(s - n, c + 1) = A(i, 3)
- Next i
- With Sheet1
- .Range("a3:m65536").ClearContents
- .[a3].Resize(s, UBound(B, 2)) = B
- End With
- End Sub
复制代码
按条件取数2.rar
(9.86 KB, 下载次数: 8)
|
|