Finding Possible Mismatch between columns

Originally Posted by Gregor y

I'm having a hard time picturing what you're asking. Since as far as Excel would care "Joel" would not only be a mismatch to "Joell", but also to "Sam", "Gorge", "Bob", ... and pretty much anything other than "Joel".

that asside, the VBA to update cell comments would look something like this:

Sub Commenting_A_cell()
    Dim c1 As Range, c2 As Range
    Set c1 = ActiveCell
    Set c2 = Range("C4")
    c1.AddComment "In column C as: " & c2.Value
End Sub

Hey Gregor Y,
I understand what you're trying to stay. All those are mismatches i agree. But I'm looking to show the closest mismatch in the comment. I hope this makes it a little more clear as to what I'm trying to achieve. And I really hope someone can help me with the code. I am unable to find help anywhere else.