Macro Question (Please Help Me Save all My time?$$)

[ahmedakhtar11]

Okay, so at work... I spend hundreds of hours checking to see whether the name in one column of an excel sheet matches the
name in the second column of the excel sheet. I'm starting to go insane and all I ever do with my life is check whether a name in the
first column Matches the one in the next one.

However, I see a pattern that there are always spaces in between the names and I know a Macro must be able to spot this!!
I was thinking something like "IF 2 Pairs of 3 consecutive matching letters that are seperated by spaces, Then highlight green."
This is literally the exact thing that my human brain does.

Because for example the name in the first column will be something like "John Doe"
and that wont match with the name in the second column which will say something like "Doe, John and Jane.

I need an excel formula that will match the names in the columns and maybe highlight the row green or something if there are maybe
2 pairs of 3 consecutive Matching letters separated by spaces. Like in my example the computer would match "ohn" and another "doe" seperated by a space
and match that with the name in the second column..

I would be eternally grateful if someone could help me with this answer and be very inclined to give them a reward..

Thanks for Listening, I have looked everywhere online and this is my last hope.

 

[Michael M]

Can you post a slightly larger sample of your data ??