本帖最后由 爱疯 于 2013-4-21 22:24 编辑
Sub Click()
Dim A, B, d, i%, s%
A = Range("a1").CurrentRegion
ReDim B(1 To UBound(A), 1 To 3)
Set d = CreateObject("scripting.dictionary")
s = s + 1
For i = 2 To UBound(A)
If d.exists(A(i, 4)) = False Then s = s + 1: d(A(i, 4)) = s
B(s, 1) = A(i, 4)
If B(s, 2) = 0 Then B(s, 2) = A(i, 1)
If B(s, 2) > A(i, 1) Then B(s, 2) = A(i, 1)
If B(s, 3) = 0 Then B(s, 2) = A(i, 1)
If B(s, 3) < A(i, 1) Then B(s, 3) = A(i, 1)
Next i
B(1, 1) = "考场": B(1, 2) = "开始号": B(1, 3) = "结束号"
[G1].Resize(s, 3) = B
End Sub
第二学期期中考试3.rar
(30.51 KB, 下载次数: 14)