请楼主测试:- Sub 个数之差()
- Dim ar, temp(9, 1), re(1 To 1, 0 To 9)
- Dim rnum As Integer, i As Integer, j As Integer, R As Integer
- ar = Sheets(1).Range("A1:A" & Sheets(1).[a65536].End(3).Row + 1)
- rnum = UBound(ar)
- For i = 0 To 1
- For j = 0 To 9
- R = rnum - i * 10 - j
- If ar(R, 1) <> "" Then
- temp(Val(Mid(ar(R, 1), 1, 1)), i) = temp(Val(Mid(ar(R, 1), 1, 1)), i) + 1
- temp(Val(Mid(ar(R, 1), 2, 1)), i) = temp(Val(Mid(ar(R, 1), 2, 1)), i) + 1
- temp(Val(Mid(ar(R, 1), 3, 1)), i) = temp(Val(Mid(ar(R, 1), 3, 1)), i) + 1
- End If
- Next j
- Next i
- For j = 0 To 9
- re(1, j) = temp(j, 1) - temp(j, 0)
- Next j
- Sheets(1).[b284].Resize(1, UBound(re, 2) + 1) = re
- End Sub
复制代码 |