Forum Discussion
Text Filter
Sample is in Sheet3 attached, but I'm missed with the logic:
- Are names always as LastName FirstName <MiddleName or Initial> where the latest is optional? Or that could be like LastName <MiddleName> FirstName?
- Names as "Calendar Amy L" and "Calendar Amy Lynn" are considered as the same. But what about "Calendar Amy J" or whatever is on the third position - is that the same "Calendar Amy"?
- Yes, all names are listed last name first name middle initial suffix (if any) ...
If the middle initial is different then yes it is a different person...
I really appreciate your help ... let me know what you think.One more question - if no initial / middle name this person consider as different to one who has no such? For example
1) Calendar Amy
2) Calendar Amy L
3) Calendar Amy Lynn
4) Calendar Amy H
2) and 3) are the same. 4) is different from 2) and 3). What about 1), is it different from all of them or it's the same as 2),3) or same as 4) and if two latest options how we shall know which one to take.
- Well, the names are listed side by side so if the name was different it could show as follows:
1. Calendar Amy Calendar Amy L
2. Smith Santa C Smith Judy
3. Fan Tara D Fan Stan
The names should only be compared row by row...
In your example, the names will only be compared to one other name. So, we know if 1 is referring to 2, 3 or 4.
Let me know if you have any other questions :)
