参与一下。。。。
- Sub ykcbf() '//2024.5.17
- r = Cells(Rows.Count, 1).End(3).Row
- Set Rng = [a2].Resize(r - 1, 5)
- With Rng
- .Parent.Sort.SortFields.Clear
- .Sort key1:=.Item(2), order1:=1, key2:=.Item(4), order2:=2, Header:=2
- End With
- arr = Rng.Value
- lc = 42
- On Error Resume Next
- For i = 1 To UBound(arr)
- If i = 1 Then arr(i, 5) = 1
- If arr(i, 2) <> arr(i - 1, 2) Then m = 0: arr(i, 5) = 1
- If arr(i, 2) = arr(i - 1, 2) Then m = m + 1: arr(i, 5) = m
- If m = lc Then m = 0
- Next
- Rng.Value = arr
- Rng.Borders.LineStyle = 1
- End Sub
复制代码
|