|
本帖最后由 lovelfg 于 2016-10-21 10:21 编辑
EXCEL里A列存放了一些编号列表,现在我想like的方法在F列统计出每一个单项编号
例如101有一个,102有4个,103有4个等等。我的思路是循环每一项进行匹配,再设置一个变量K为计数器。
代码如下:
Sub newcount()
Dim i As Integer, j As Integer, k As Integer, l As Integer
k = 0
For j = 2 To 6
For i = 2 To 9
If Range("E" & j) Like "*" & Range("A" & i) & "*" Then
k = k + 1
End If
Next
Next
Range("F" & j) = k
End Sub
然而不知道为什么,所得到的结果完全是错的,求大神指正一下,谢谢
Sub newcount()
Dim i As Integer, j As Integer, k As Integer, l As Integer
k = 0
For j = 2 To 6
For i = 2 To 9
If Range("a" & i) Like "*" & Range("e" & j) & "*" Then
k = k + 1
End If
Next
Range("F" & j) = k: k = 0
Next
End Sub
*101/102/103* like 101 你是这样对比所以不对
|
|