how compare two names, diffcult to find name miss match in 2 columns

[vengatvj]

Here i gave sample file, how to compare two names?

some names looks different like this , but all this name is not wrong,

ROSE MARRY Mrs ROSEMARRY

jack dossan mr jackdHossan

michael jorge mr michael

i want display completely wrong name between two column
example

Rajesh kumar Mr raguram

venkatesh mr vinoth

rameshkumar mr ramarajan

silambarasan mr ashokumar

all the above names wrong.

i want differentiate this names in c column, if name wrong then display as 'NAME MISMATCH"

If name correct should be blank in C column,

[Moo the Dog]

This will get you close, but it flags more "incorrect names" than what you point out - since they aren't exact matches... not sure how to perform a "fuzzy" match...

Paste this in C2 and fill down:

Please Login or Register  to view this content.

- Moo

[vengatvj]

yah Moo the Dog, its working as you told, getting more name "incorrect names" but its ok, i can manage, thank you...

if anyone know how to exact match pls reply me in this thread..

[Moo the Dog]

Here's a version that results in fewer 'false-positives':

Please Login or Register  to view this content.

- Moo

[vengatvj]

thank you very much.. i have 109 numbers right now, 2 error only your formula given..

see excel,

thanks

[Moo the Dog]

Glad to help!

- Moo

If you could, please click on the small 'Add Reputation' star at the lower-left corner of one of my posts to add to my "Rep" here on the boards. Thanks!

[vengatvj]

Thanks again...