Finding similar names in a list of employees

[bugsly]

Hi all,

I have a list of 7000 employees and am trying to find any names that are similar to each other. I tried leveraging VLOOKUP however I can only find an exact match using this method. I also tried downloading the Fuzzy Look Up add in however I get an error about not have access to a registry when trying to use it. Does anyone know of a formula to accomplish this? I was thinking of using wildcards but am not good with figuring out excel formulas . Any help would be greatly appreciated

Thanks everyone!

 

[Fazza]

That is clearer to me now, thanks.

I'm not sure if I can help with the question. I'll give it some more thought, though.

On a different tack. One thing that seems obvious but I guess isn't simple or it would be in place already, is have employees (or delegates making the arrangements) give the employee's unique ID as well as name when making bookings.

 

[bugsly]

That is clearer to me now, thanks.

I'm not sure if I can help with the question. I'll give it some more thought, though.

On a different tack. One thing that seems obvious but I guess isn't simple or it would be in place already, is have employees (or delegates making the arrangements) give the employee's unique ID as well as name when making bookings.

I definitely agree! Unfortunately, it is a limitation of the booking system Thank you for your time and help. If you think of anything, I'd definitely be willing to try it out!

 

[Fazza]

What about having the booking system auto-grow the list?

So when one of these mis-identified names is newly identified as such, it gets added at that time to a table. With time the list will grow and be available. Importantly (I think) this list should also have the unique identifiers for these names that might be mixed up.