Excel Comparing two columns


Joined
Nov 8, 2019
Messages
1
Reaction score
1
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.
 
Ad

Advertisements

Joined
Feb 21, 2018
Messages
196
Reaction score
79
Greeting.
Attached please find an excel file ...Please follow the following steps
1. copy AD data in the sheet named as AD (paste on A1...no header please)
2. copy Library data in the sheet named as Library (paste on A1...no header please)
3. Run the interface it will make a master list for you ensuring "no-duplicates"
 

Attachments


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top