- Sub Macro1()
- Dim arr, brr, i&, j%
- w = Array("、", ",")
- For i = 0 To UBound(w)
- [a2:c11].Replace w(i), ""
- Next
- arr = [a2:c11]
- ReDim brr(1 To UBound(arr), 1 To 1)
- For i = 1 To UBound(arr)
- If arr(i, 1) <> arr(i, 2) Then
- x = Split(arr(i, 3))
- For j = 0 To UBound(x)
- If x(j) Like "*票?车" Then arr(i, 3) = Replace(arr(i, 3), x(j), "")
- If x(j) Like "*#*" Then
- brr(i, 1) = IIf(brr(i, 1) = "", x(j), brr(i, 1) & " " & x(j))
- arr(i, 2) = arr(i, 2) + Val(Mid(x(j), 2)): arr(i, 3) = Replace(arr(i, 3), x(j), "")
- End If
- Next
- End If
- Next
- For i = 1 To UBound(arr)
- If arr(i, 1) <> arr(i, 2) Then
- x = Split(Trim(arr(i, 3)))
- y = UBound(x) + 1
- n = (arr(i, 1) - arr(i, 2)) / y
- For j = 0 To UBound(x)
- brr(i, 1) = brr(i, 1) & " " & x(j) & n
- Next
- End If
- Next
- Range("d2").Resize(UBound(brr)) = brr
- End Sub
复制代码 |