Hi all,
I have a pretty simple (or maybe not?) task to perform, in a small-ish spreadsheet.
Data is imported from two different software applications; one is a website form and another is an official "register" of a sort. In the register the names and last names are taken from ID's properly, in separate fields. On the website however, users enter a plethora of, well, "forms" of their names .
What I need to do is search for strings entered through a website form, in a dataset imported from the official register.
Final goal: count the number of matches; a simple numeric value, nothing else.
Example below, I hope this makes it a bit easier.
Many thanks in advance!
<colgroup><col><col><col><col></colgroup><tbody>
</tbody>
I have a pretty simple (or maybe not?) task to perform, in a small-ish spreadsheet.
Data is imported from two different software applications; one is a website form and another is an official "register" of a sort. In the register the names and last names are taken from ID's properly, in separate fields. On the website however, users enter a plethora of, well, "forms" of their names .
What I need to do is search for strings entered through a website form, in a dataset imported from the official register.
Final goal: count the number of matches; a simple numeric value, nothing else.
Example below, I hope this makes it a bit easier.
Many thanks in advance!
name (from App 1) | Name from (App 2) | Last name from (App 2) | match |
John Smith | Marco Polo | The Third | FALSE |
Steve Ivan Hoe | Jedi | Knight | FALSE |
Janice Murphy | John | Smith | TRUE |
Marc Anthony | Joao | Gilberto | TRUE |
Gilberto Joao | Steve | Irvine | FALSE |
James Marshall | Hendrix | FALSE | |
Little | Cat | FALSE |
<colgroup><col><col><col><col></colgroup><tbody>
</tbody>