|
Sub test2()
Dim A, B(1 To 10000, 1 To 2), i, s, n
Sheets(1).Select
Range("A:B").Sort Key1:=Range("A1"), Order1:=xlAscending, _
Key2:=Range("B1"), Order2:=xlAscending, Header:=xlYes
A = Range("a1:b" & Range("a65536").End(3).Row + 1)
n = 8
For i = 2 To UBound(A) - 1
s = s + 1
B(s, 1) = A(i, 1)
B(s, 2) = A(i, 2)
'当与下次不一样时,就修改s
If A(i, 1) <> A(i + 1, 1) Or A(i, 2) <> A(i + 1, 2) Then
s = IIf(s Mod n = 0, s, (s \ n + 1) * n)
End If
Next i
With Sheets(2)
.Select
.Range("a:b") = ""
.[a1].Resize(s, 2) = B
End With
End Sub
排课3.rar
(15.15 KB, 下载次数: 21)
|
|