|
发表于 2012-12-7 14:49
|
显示全部楼层
本楼为最佳答案
Sub 排考号()
Dim i As Integer, k As Integer
Range("A2:C416").Sort Key1:=Range("C2"), Order1:=xlDescending
For i = 2 To 416
If Range("a" & i) = Range("a" & i).Offset(-1, 0) Then
k = 0
Do While Range("a" & i + k) = Range("a" & i).Offset(-1, 0)
k = k + 1
Loop
arr = Range("a" & i & ":c" & i)
brr = Range("a" & i + k & ":c" & i + k)
Range("a" & i & ":c" & i) = brr
Range("a" & i + k & ":c" & i + k) = arr
End If
Range("d" & i) = Range("d" & i).Offset(-1, 0) + 1
Next i
Range("d1") = "考号"
End Sub
|
|