Blog Post

Core Infrastructure and Security Blog
2 MIN READ

Excel Functions - Data Comparison and Manipulation

AMARSIGLIA's avatar
AMARSIGLIA
Icon for Microsoft rankMicrosoft
Nov 01, 2019
First published on MSDN on Jun 09, 2017 Ok so you might ask what does this posting have to do with FIM, MIM, or Identity Management … Well it doesn't not Directly. I was involved in a scenario wh...
Updated Feb 20, 2020
Version 3.0
AnthonyMarsiglia
alexike's avatar
alexike
Copper Contributor
Sep 25, 2020

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