Excluding from first list names in a 2nd list

[dsciola]

Say I have a list of names in 2 lists, one list has more names than the other. What's a good formula for EXCLUDING from the list with more names any names that are also in the smaller list?

This is a simple example, issue Im dealing with has thousands of names. Thanks! Could really use a solution for this...

Dom

OK...uploadeer is not working so cant attach spradsheet...best i can do is this...


List 1
Dom
Joe
Terry

List 2
Joe

OUTPUT
Dom
Terry

Any thoughts? Could really use some help here...and a working upload tool would be ncie too,,,

[wenqq3]

Simple excel formula,
List1 @ Column A; List2 @ Column B

Please Login or Register  to view this content.

drag down, if found it will show the name,else will give you #N/A. Filter all except #N/A, then delete the repeat name.

[benishiryo]

hi dsciola. another alternative is this array formula. assuming data in A2:B10, then in C2:
=IFERROR(INDEX($A$2:$A$10,SMALL(IF(COUNTIF($A$2:$A$10,$B$2:$B$10)=0,ROW($A$2:$A$10)),ROWS(D$2:D2))-ROW($A$2)+1)&"","")

...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you might get an error or a clearly incorrect answer. Press F2 on that cell and try again.

[azumi]

Another solutions bro :

=IFERROR(INDEX($A$2:$A$4,SMALL(IF(ISNA(MATCH($A$2:$A$4,$B$2:$B$4,0)),ROW($A$2:$A$4)-ROW($A$2)+1),ROW(1:1))),"")

just see the files

Azumi

[dsciola]

Thanks wenqq3, works great!

Dom

[wenqq3]

Thanks for feedback :D
If the problem is solved, please mark your thread as Solved: Click Thread Tools above your first post, select "Mark your thread as Solved".