Excel - compare names in two cells in different order
I need to compare the following
Cell 1 John Peter henderson
Cell 2 peter John Henderson
Result Match
Cell 1 Anne jolie beuhler
Cell 2 Jolie Anne
Result NO MATCH
Cell 1 Kate spade lee
Cell 2 susan kate spade
Result NO MATCH
I need a perfect match for the name in any order.
No comments:
Post a Comment