Sep 24 2020 04:27 PM
Hello
Please what formula should i use to compare two cells that have more than one name. I want to compare names in two columns but the cells have both the first name, middle name and last. Is there any formula i can use to make this easy. Also some cells have the same names but some were mispelt, hence it returning a mismatch result
Sep 25 2020 07:24 AM
So much here, I would think, depends on the magnitude of the issue: How may rows of names are we talking about?
Anyway, if I were in your place, I'd look at some combination of:
That's just for starters. There may be ways you could use wildcard characters as well. But as I said at the start, it all depends on magnitude.
I'm sure you'll get some other suggestions; let's home some are more helpful.