output data not in 2 lists

[Guest]

I think this is easy, but need help. I have 2 lists of last/first names. I'm
trying to create new columns where the lists DON'T exactly match - case is
immaterial.
Example:
Last1 First1 Last2 First2 Not Last Not First
smith jon smith john (I don't expect/need smith john here)
doe amy doe joy doe joy

Please help!

Best,
T

 

[Frank Kabel]

Hi
as a starting point:
http://www.cpearson.com/excel/duplicat.htm#InOneNotOther

 

[Biff]

I would love to see the algorithm that evalutes Smith Jon
and Smith John as being equal and therefor excludes those
names from the OP's filtered list!

Biff

 

[Frank Kabel]

Hi
there're some algorithmns which do this kind of pattern match (some
kind of 'fuzzy' logic). If you search the Google archives you'll find
several )