HOW TO COMPARE NAMES FOR EXACT, NO MATCH, CLOSE MATCH IN EXCEL

Closed
Report
Posts
1
Registration date
Saturday March 19, 2016
Status
Member
Last seen
March 19, 2016
-
I have 3 millions database of names in excel, I want to compare each rows for match, close match, no match, first name juxtapose for other names, & abbreviated initials.

See above my manual attempt

guys, i can count on you to help. my boss is on my ass to deliver in 3 days.
Strive to be kind & cute each day