Extracting non-Duplicates from Two Lists

copyboy007

Board Regular
Joined
May 17, 2005
Messages
60
I have two lists of names where the first column is the master list and the second column is a partial list of those people.

How do I create a third column listing only those people from the first column that are not in the second column (i.e., removing duplicates)?
 

Some videos you may like

Excel Facts

How to show all formulas in Excel?
Press Ctrl+` to show all formulas. Press it again to toggle back to numbers. The grave accent is often under the tilde on US keyboards.

Domenic

MrExcel MVP
Joined
Mar 10, 2004
Messages
19,379
Assuming that A2:A10 contains the first list, and B2:B6 contains the second list, try the following formula which needs to be confirmed with CONTROL+SHIFT+ENTER...

C2, copied down:

=INDEX($A$2:$A$10,MATCH(TRUE,IF(ISNA(MATCH($A$2:$A$10,$B$2:$B$6,0)),ISNA(MATCH($A$2:$A$10,$C$1:C1,0))),0))

Hope this helps!
 

Domenic

MrExcel MVP
Joined
Mar 10, 2004
Messages
19,379
Note that I've edited the formula. Also, the formula will not return any values that appear in the second list and not the first...
 

Watch MrExcel Video

Forum statistics

Threads
1,114,058
Messages
5,545,757
Members
410,704
Latest member
Cobber2008
Top