HI,
I have two pairs of columns that contain data from different sources. I need to compare the two pairs and get rid of any that don't appear in both pairs (they are first names and surnames). The issue is that there are several duplicate surnames in the surname columns which I think may be causing the issue. I've tried various different ways but the results are either plain wrong or inconsistent.
I've also tried combining the first and second names to fullnames and then comparing the two fullname columns but this is also not working.
What I would like is an output for each name that says something like "John Smith is only in AD"," John Smith is only in Library" or "John Smith is in both"
The first (pair of) columns, AD, has more entries than the second (pair of) columns.
I know this should be simple but I can't find a way.
Thanks for listening
Mark P.
I have two pairs of columns that contain data from different sources. I need to compare the two pairs and get rid of any that don't appear in both pairs (they are first names and surnames). The issue is that there are several duplicate surnames in the surname columns which I think may be causing the issue. I've tried various different ways but the results are either plain wrong or inconsistent.
I've also tried combining the first and second names to fullnames and then comparing the two fullname columns but this is also not working.
What I would like is an output for each name that says something like "John Smith is only in AD"," John Smith is only in Library" or "John Smith is in both"
The first (pair of) columns, AD, has more entries than the second (pair of) columns.
I know this should be simple but I can't find a way.
Thanks for listening
Mark P.