Hi fellow excel experts,
I have to identify names from a excel spreadsheet where the first names, middle names and last names are not in the correct sequence. The names are in 1 column.
Is there a formula i can use to identify a unique person even though the sequence is incorrect?
E.g.
Scenario 1: First name, Last Name
John Smith vs (First Name, Last Name)
Smith John (Last Name, First Name)
- result would show 1 unique person
Scenario 2: First Name, Middle Name, Last Name
John Andrew Smith
Smith John Andrew
Andrew John Smith
- result would show 1 unique person
If anyone could please help it would be great! I'm going to have hundreds of names to comb through
Thanks in advance
I have to identify names from a excel spreadsheet where the first names, middle names and last names are not in the correct sequence. The names are in 1 column.
Is there a formula i can use to identify a unique person even though the sequence is incorrect?
E.g.
Scenario 1: First name, Last Name
John Smith vs (First Name, Last Name)
Smith John (Last Name, First Name)
- result would show 1 unique person
Scenario 2: First Name, Middle Name, Last Name
John Andrew Smith
Smith John Andrew
Andrew John Smith
- result would show 1 unique person
If anyone could please help it would be great! I'm going to have hundreds of names to comb through
Thanks in advance