Hi Team,
I have a list of around 1000 of names and I need to check to what extent, the names are matching. I need marching score and one common name as result for all the names in column A
Kindly refer example below:
| Name | Result |
| Saif /Name | Saif /Name |
| Name/Saif | Saif /Name |
| Name/Saif MR | Saif /Name |
| MR Name/SaiF | Saif /Name |
| Kara/Tim | |
| Kara,Tim | |
| Dim/Tore Show | |
| DimTore/ Show | |
| Dim/Show tore | |
| ERS/COL | |
| RERS/COL | |
| ERS/COL, | |
| NDLER/JERRY L | |
| NDLER/L JERRY | |
| NDLER/JERRY | |
| NDLER/L, JERRY | |
| NDLER/JERRY, | |
| NDLER/L JERRY ANDREW | |
| HUG/XUEN | |
| XUEN/HUG | |
| XUEN,HUG | |
| XUEN,HUG MS | |
| XUEN,HUG DR | |
