|
请测试!- Sub wanao()
- Dim a As Integer, a1 As String, a2 As String, a3 As String, jShu As Integer
- a = Cells(Rows.Count, "g").End(xlUp).Row
-
- For x = 2 To a
- '两码合
- a1 = Right(Val(Mid(Cells(x, "g"), 1, 1)) + Val(Mid(Cells(x, "g"), 2, 1)), 1)
- a2 = Right(Val(Mid(Cells(x, "g"), 1, 1)) + Val(Mid(Cells(x, "g"), 3, 1)), 1)
- a3 = Right(Val(Mid(Cells(x, "g"), 2, 1)) + Val(Mid(Cells(x, "g"), 3, 1)), 1)
- Cells(x, "h") = a1 + a2 + a3
- '胆码出现
- For y = 1 To 3
- If InStr(1, Cells(x, "i"), Mid(Cells(x, "g"), y, 1), 1) Then
- jShu = jShu + 1
- End If
- Next
- Cells(x, "j") = jShu
- jShu = 0
- '两码全出现
- For y = 1 To 3
- If InStr(1, Cells(x, "i"), Mid(Cells(x, "h"), y, 1), 1) Then
- jShu = jShu + 1
- End If
- Next
- Cells(x, "k") = jShu
- jShu = 0
- Next
- End Sub
复制代码 |
|