Comparing 4 lists of names?

Discussion in 'Mac Programming' started by virilep, Dec 14, 2007.

Most Liked Posts
  1. virilep, Dec 14, 2007

    virilep macrumors member

    Joined:
    Aug 22, 2006
    #1
    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? :confused:
     
    share
    + Quote Reply
  2. wrldwzrd89, Dec 14, 2007

    wrldwzrd89 macrumors G5

    wrldwzrd89

    Joined:
    Jun 6, 2003
    Location:
    Solon, OH
    #2
    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:
    Code:
    =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.
     
    share
    + Quote Reply
(You must log in or sign up to post here.)

Share This Page