macOS Comparing 4 lists of names?

[virilep]

Hi everyone,

I've been trying to do this for hours. I have 4 lists of names. Each one with a list of about 100-400 names. I wanted to compared each one against each other. Anyone know how I can do this? They are in excel right now.

last, first, last, first etc. 8 columns.

I hope someone can help?

 

[wrldwzrd89]

I've done stuff like this before. The easiest way I know of to find places where the names are different is to use formulas combined with conditional formatting in columns 9 and 10.

For example:

=IF(AND(EXACT(A1,C1),EXACT(A1,E1),EXACT(A1,G1),EXACT(C1,E1),EXACT(C1,G1),EXACT(E1,G1)),TRUE,FALSE)

for the first names, in column 9. Just fill down for the rest of the data.

Conditional formatting can be added to this to make any FALSE results stand out, so you can fix them.