|
给个vba的- Sub 排序()
- Dim arr, brr(), temp1, temp2
- Dim i, j As Long
- arr = Range("a2:b" & Range("a65536").End(xlUp).Row)
- For i = 1 To UBound(arr) - 1
- For j = i + 1 To UBound(arr)
- If arr(i, 2) < arr(j, 2) Then
- temp1 = arr(i, 1)
- temp2 = arr(i, 2)
- arr(i, 1) = arr(j, 1)
- arr(i, 2) = arr(j, 2)
- arr(j, 1) = temp1
- arr(j, 2) = temp2
- End If
- Next j
- Next i
- ReDim brr(1 To UBound(arr))
- brr(1) = 1
- For i = 2 To UBound(arr)
- If arr(i, 2) <> arr(i - 1, 2) Then
- brr(i) = brr(i - 1) + 1
- Else
- brr(i) = brr(i - 1)
- End If
- Next i
- Range("c2:e65536").ClearContents
- Range("C2").Resize(UBound(arr), 2) = arr
- Range("e2").Resize(UBound(brr), 1) = Application.Transpose(brr)
- End Sub
复制代码
自动排名求助.rar
(9.88 KB, 下载次数: 12)
|
|