| View previous topic :: View next topic |
| Author |
Message |
adamdidthis
Newbie
Joined: 30 Aug 2009
Posts: 1
|
 Posted: Sun Aug 30, 2009 7:20 pm Post subject: compare two lists |
 |
|
OK I am new to all of this,
I have two lists:
HD1
HD2
HD3
OSB1
OSB3
OSB4
and
HD2
HD1
OSB4
HD2
OSB3
HD3
I need to compare both lists and then show in a single cell which is missning from list 2, it needs to be the word two not how many are missing.
Any help would be appreciated. |
|
| Back to top |
|
 |
Villeroy
Super User
Joined: 04 Oct 2004
Posts: 10065
Location: Germany
|
| Posted: Mon Aug 31, 2009 2:41 am Post subject: |
|
|
=ISNA(MATCH($A1;List2;0)) => TRUE if A1 not in List2.
=IF(ISNA(MATCH($A1;List2;0));$A1;"") => A1 if A1 not in List2, else emtpy string.
_________________
Rest in peace, oooforum.org
Get help on http://forum.openoffice.org |
|
| Back to top |
|
|
|
