Comparing 4 lists of names?

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

  1. 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:
     
  2. 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 This Page