Compare two column

[psamu]

I have two column in excel I want find column differences ; I have below two column I want to find out based on the employee name check entire Manager column find any differences in manager name.

Emp Name Manger

Mike John
Mike Victor

 

[mumps]

Do you want to know which employee names are not manager names?

 

[psamu]

Do you want to know which employee names are not manager names?

Yes, employee name may be appearing several times in the data set, but if manager is different then I want find. Thanks

 

[mumps]

I'm assuming that the Employee Name is in column A and the manager is on column B. This will highlight in red every employee who is not a manager.

Sub CompareLists()
    Application.ScreenUpdating = False
    Dim Rng As Range, RngList As Object
    Set RngList = CreateObject("Scripting.Dictionary")
    For Each Rng In Range("B1", Range("B" & Rows.Count).End(xlUp))
      If Not RngList.Exists(Rng.Value) Then
        RngList.Add Rng.Value, Nothing
      End If
    Next Rng
    For Each Rng In Range("A1", Range("A" & Rows.Count).End(xlUp))
      If Not RngList.Exists(Rng.Value) Then
        Rng.Font.ColorIndex = 3
      End If
    Next Rng
    RngList.RemoveAll
    Application.ScreenUpdating = True
End Sub

 

[psamu]

I'm assuming that the Employee Name is in column A and the manager is on column B. This will highlight in red every employee who is not a manager.

Sub CompareLists()
    Application.ScreenUpdating = False
    Dim Rng As Range, RngList As Object
    Set RngList = CreateObject("Scripting.Dictionary")
    For Each Rng In Range("B1", Range("B" & Rows.Count).End(xlUp))
      If Not RngList.Exists(Rng.Value) Then
        RngList.Add Rng.Value, Nothing
      End If
    Next Rng
    For Each Rng In Range("A1", Range("A" & Rows.Count).End(xlUp))
      If Not RngList.Exists(Rng.Value) Then
        Rng.Font.ColorIndex = 3
      End If
    Next Rng
    RngList.RemoveAll
    Application.ScreenUpdating = True
End Sub

Thanks

 

[mumps]

You are very welcome.

 

[psamu]

Sorry, I for the confusion. Column A Employees ID, Column B has Manager Name, Column A Employees ID has multiple times, (can be many times repeated), I am looking for If Column A Employee ID is same and managers Name are different in Column B.
Eg, ID 123 Manager is Mike, and another record shows Employee ID123 but Manager is John. If Manager is same for both, do not high light. Hope this is clear. Thank you.

 

[mumps]

Can there be more than 2 manager names for any one employee ID?

 

[psamu]

Can there be more than 2 manager names for any one employee ID?

Yes, that is right. Thanks

 

[mumps]

Let's say you have something like the following:

ID Manager Name
1 Mike
1 George
1 Mike
1 George
2 John
2 Mary
2 John
2 Mary
2 John

There are 4 people with an ID of "1" where 2 of the people have Mike as a manager and 2 have George as a manager. How do you decide which to highlight? Same for ID "2".