Finding possible duplication

[Syed_001]

Hi,

I have a set of data (vendor & customer name). There seems to be a duplication but most of the duplication are not exact. Example are as below:
- Johnson Charles and Johnson Charhles

- ABC PTE LTD - ABC PTL. LTD.

- Gobinath D/O Ramasamy and Gobinath

My idea is to find maybe 50% similarities and mark it. How do I find duplication if the names are not exact?

[#2]

https://techcommunity.microsoft.com/t5/excel/aligning-1st-and-last-name-column-in-excel-with-similar...

[#3]

@Syed_001 

Ever heard Fuzzy Lookup? It's an add-in that is similar to lookup function but you can use it to lookup for a data which is not exactly the same as your lookup value.
you can refer here> How to use the Fuzzy Lookup add-in in Microsoft Excel - YouTube