Hi Guys
How do I identify name mismatch between two columns. Each cell has a person’s last name followed by a backward slash then his first and middle name afterwards (middle name might not always be included). Please check out the attachment.Name.xlsx
If one of the three names on the first column is similar to any type of the names on the second then I want it to mark as acceptable. I am a dummy when it comes to Excel and I’d appreciate it if anyone can help me on this. Thanks
Bookmarks