Sub tiqv()
Dim a, b
a = Application.CountA([a:a])
For b = 1 To a
If Cells(b, 1) Like "*" & Cells(1, 3) & "*" Then
Cells(b, 2) = Cells(b, 1)
Else
Cells(b, 2) = ""
End If
Next
End Sub
水平比较低,代码比较长
Sub tiqv()
Dim a, b
a = Application.CountA([a:a])
For b = 1 To a
If Cells(b, 1) Like "*" & Cells(1, 3) & "*" Then
Cells(b, 2) = Cells(b, 1)
Else
Cells(b, 2) = ""
End If
Next
End Sub
水平比较低,代码比较长