Sub a() Dim d As Object Dim i%, k% Range("b:b").ClearContents Set d = CreateObject("Scripting.Dictionary") For i = 3 To [c65536].End(3).Row d(Cells(i, 3).Value) = "*" Next For k = 3 To [a65536].End(3).Row Cells(k, 2) = d(Cells(k, 1).Value) Next End Sub
Sub a() Dim i% For i = 3 To [a65536].End(3).Row If CInt(Cells(i, 1)) = CInt(Cells(i, 3)) Then Cells(i, 2) = "*" Else Cells(i, 2) = "" End If Next End Sub
Sub a() Dim d As Object Dim i%, k% Range("b:b").ClearContents Set d = CreateObject("Scripting.Dictionary") For i = 3 To [c65536].End(3).Row d(Cells(i, 3).Value) = "*" Next For k = 3 To [a65536].End(3).Row Cells(k, 2) = d(Cells(k, 1).Value) Next End Sub