Hello!
I have two different sets of data and I'm trying to find a way to match the names between them which are very different in format. Examples below:
Sherry A Aaholm
/// Aaholm, Sherry A. (Board)
Lawrence (Larry) P O'Reilly
///O'Reilly, Lawrence P. (Board)
Steven (Steve) J Strobel
///Strobel, Steven J. (Prior Board)
Google docs Link with the data set since it's over 500kb. Theres also unique entries without matches in the other data set. The ID's are also different since the data comes from different sources.
Data Set
I'm currently trying to solve the problem with basic excel formulas but I'm not sure how well that will go.
If anyone has any ideas on how to solve this issue I'd appreciate it.
Edit: I'm using office 365 if that matters.