|
- Sub xx()
- Dim arr, brr(), d, n%, i%, str$
- Set d = CreateObject("Scripting.Dictionary")
- With Sheet1
- n = .Cells(.Rows.Count, 2).End(xlUp).Row
- arr = .Range("B2:C" & n)
- str = "I" & Mid(arr(1, 1), 3, 2) & Format(Month(arr(1, 1)), "00") & "001"
- ReDim Preserve brr(1 To 1)
- brr(1) = str
- x = 1
- For i = 2 To n - 1
- ReDim Preserve brr(1 To i)
- If x < 3 And arr(i, 1) = arr(i - 1, 1) And arr(i, 2) = arr(i - 1, 2) Then
- brr(i) = str
- x = x + 1
- Else
- str = "I" & Mid(arr(i, 1), 3, 2) & Format(Month(arr(i, 1)), "00") & Format(Right(str, 3) + 1, "000")
- brr(i) = str
- x = 1
- End If
- Next
- .Range("D2:D" & n) = Application.WorksheetFunction.Transpose(brr)
- End With
- End Sub
复制代码 |
|