kittymongo
New Member
- Joined
- Feb 6, 2018
- Messages
- 16
I need help with a formula or set of formulas to match 2 columns of names. One column will have first and last name and the second column will have last comma first name and sometimes a middle initial. How can I compare the 2 to match the data sets without the middle names, suffixes, etc. I only want first and last name matches.
<colgroup><col><col></colgroup><tbody>
</tbody>
Thank you -
Jane Smith | Smith, Jane A |
John Snow | Snow, John Wick |
<colgroup><col><col></colgroup><tbody>
</tbody>
Thank you -