Hi, and welcome to ExcelForums. This place has taught me a ton, and I'm just now myself starting to feeling comfortable and confident enough in offering help and advice back to other's.
How's something like this?
I did a compare of the two fields and returned a True or False. True is a Match found. That formula is as follows
Then I searched that True/False cell range hiding any 'True' Values.
Sub HideMatch()
Dim rows_rng As Range, rows2hide As Range
Dim rCell As Range
Set rows_rng = Range("C2:C5")
For Each rCell In rows_rng
If rCell.Value = "True" Then
If rows2hide Is Nothing Then Set rows2hide = rCell Else Set rows2hide = Union(rCell, rows2hide)
End If
Next
Application.ScreenUpdating = 0
rows_rng.EntireRow.Hidden = 0
If Not rows2hide Is Nothing Then rows2hide.EntireRow.Hidden = 1
Application.ScreenUpdating = 1
End Sub
Sample Attached
Bookmarks