Compare 2 Columns and List Values That Dont Match in Column 3

[yelkrab]

The scenario I have is a list (Column A) of IP addresses that will be scanned/pinged. Then I have a list (Column B) of IP addresses that came back with a response. I would like Excel to compare the two lists and return the addresses that DO NOT match, the ones that did not come back with a response, and insert them in Column C. Until now I have had Excel compare Column A to Column B and highlight the matches, but moving forward this will not be efficient for identifying the addresses that DONT match. If I can have the unmatched values in Column A listed in Column C life would be easier. Thanks for any help!

 

[Marcílio_Lobão]

yelkrab, Good evening.

Try to use:

C1 --> FORMULA --> =IF(A1<>B1, A1, "")

Is that what you want?

I hope it helps.

 

[Fluff]

If you're interested in a vba solution, how about

Sub NonMatch()

   Dim Cl As Range
Application.ScreenUpdating = False
   With CreateObject("scripting.dictionary")
      For Each Cl In Range("B2", Range("B" & Rows.Count).End(xlUp))
         If Not .exists(Cl.Value) Then .Add Cl.Value, Nothing
      Next Cl
      For Each Cl In Range("A2", Range("A" & Rows.Count).End(xlUp))
         If Not .exists(Cl.Value) Then Range("C" & Rows.Count).End(xlUp).Offset(1).Value = Cl.Value
      Next Cl
   End With
End Sub

This assumes that you have a header row in row1

 

[yelkrab]

Awesome, thanks a bunch. Will play around with this!