View original (French)

Compare two columns

hunter_x_hunter Posted messages 51 Status Member -  
Le Pingou Posted messages 12279 Registration date   Status Contributor Last intervention   -
Hello,
I want to compare two lists of names in an OpenOffice Calc document
column A is the 2009 members list and column B is the 2010 members list
I would like to display in a third column the names that are not present
in list 2
thank you in advance
Configuration: Windows Vista Firefox 3.0.13

4 answers

  1.
    Le Pingou Posted messages 12279 Registration date   Status Contributor Last intervention   1 478
     
    Hello,
    A suggestion:
    the first line is for the titles, the data starts in line 2
    column A = list 2008
    column C = list 2009
    in cell D2 the formula: =IF(ISERROR(MATCH(A2,$C$2:$C$1000,0)),"",A2)
    then drag it down
    The result: Duplicate values are displayed in column B

    --

    Best regards.
    Jean-Pierre
    4
  2. hunter_x_hunter Posted messages 51 Status Member 2
     
    Thank you very much
    I will give it a try and keep you updated
    see you later
    0
  3. hunter_x_hunter Posted messages 51 Status Member 2
     
    I tested the formula, it works except that the duplicate name appears in column D
    but that doesn't bother me. Thank you for your help, have a nice end of the day.
    0
  4. Le Pingou Posted messages 12279 Registration date   Status Contributor Last intervention   1 478
     
    Thank you hunter_x_hunter,
    Yes, it was my mistake with the formula in column "B," cell "B2," I apologize for that.

    --

    Best regards.
    Jean-Pierre
    0