|
测试一下。
285行数据N13-N14+1手工处理了一下,
如果表格确这样数据再另行更改一下代码。- Sub test()
- Dim arr, brr(1000, 1 To 1), ar, br, i%, j%, m&, n&
- arr = [a3].CurrentRegion
- For i = 2 To UBound(arr)
- m = 0: n = 0
- ar = Split(arr(i, 1), "、")
- For j = 0 To UBound(ar)
- If InStr(ar(j), "-") Then
- br = Split(ar(j), "-")
- If IsNumeric(Left(br(0), 1)) Then
- n = Abs(br(0) - br(1))
- Else
- n = Abs(Mid(br(0), 2) - Mid(br(1), 2))
- End If
- End If
- m = m + n
- Next
- brr(i, 1) = m
- Next
- [c1].Resize(i - 1) = brr
- End Sub
复制代码
使用情况统计表 ().rar
(22.17 KB, 下载次数: 3)
|
|