I have two long lists of names, and I'm trying to see where the differences in the lists are i.e. are there extra people in one list, and if so who.
I'm thinking that a good way to do this would be to use the match function, and then you can see where there are any errors, and hence the differences in the list.
My problem is a name in one list is not the same as it is in the other list, for example in one list we have Bob Mortimer, and in the other list we gave Mr Bob J Mortimer. I tried to get around this by using wildcards, but it didn't seem to work and I just kept getting #N/A
The formula I used is =MATCH("*"&F9&"*"&G9&"*",ListPersonnel!$E$9:$E$1287,0)
where F9 and G9 are first name and last name respectively
I also tried the search function =SEARCH("*"&B3&"*"&C3&"*",ListPersonnel!$E$9:$E$1287)
, but again, to no avail.
I'm fairly certain I'm using these forumlas wrong, but I'm unsure how I can use either correctly
Any help would be appreciated.
Thanks