View original (French)

Compare two columns

hunter_x_hunter Posted messages 51 Status Membre -  
Le Pingou Posted messages 12375 Registration date   Status Contributeur 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 réponses

Réponse 1 / 4
Le Pingou Posted messages 12375 Registration date   Status Contributeur Last intervention   1 476
 
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
Réponse 2 / 4
hunter_x_hunter Posted messages 51 Status Membre 2
 
Thank you very much
I will give it a try and keep you updated
see you later
0
Réponse 3 / 4
hunter_x_hunter Posted messages 51 Status Membre 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
Réponse 4 / 4
Le Pingou Posted messages 12375 Registration date   Status Contributeur Last intervention   1 476
 
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