|
- Sub justtest()
- Dim Arr, D, i&, ArrR(1 To 60000, 1 To 240), j As Byte, iR&, iC As Byte, k&
- Set D = CreateObject("scripting.dictionary")
- Arr = Range("A1").CurrentRegion.Value
- For i = 2 To UBound(Arr, 1)
- If D.exists(Arr(i, 1)) Then
- D(Arr(i, 1)) = Array(D(Arr(i, 1))(0), D(Arr(i, 1))(1) + 1)
- Else
- k = D.Count * 5 + 1
- D.Add Arr(i, 1), Array(k, 1)
- For j = 1 To 4
- ArrR(k, j) = Arr(1, j)
- Next j
- End If
- iR = (D(Arr(i, 1))(1) - 1) Mod 4 + 1
- iC = Application.RoundUp(D(Arr(i, 1))(1) / 4, 0)
- For j = 1 To 4
- ArrR(D(Arr(i, 1))(0) + iR, iC * 5 - 5 + j) = Arr(i, j)
- Next j
- Next i
- Range([f1], Cells(Cells.Count)).ClearContents
- Range("f1").Resize(D.Count * 5, 240) = ArrR
-
- End Sub
复制代码
问题.rar
(10.42 KB, 下载次数: 26)
|
|