Match two columns against each other and find the missing or extra items

[johnwetherby]

Hi
I have two lists of names and wish to find which names from the first list don't appear in list two and vice versa. How can I do this?

 

[Peter_SSs]

Welcome to the MrExcel board!

Is this the sort of thing you mean?

23 11 15.xlsm
	A	B	C	D	E
1	List A	Names Missing from List B		List B	Names Missing from List A
2	Name 1	Name 2		Name 7	Name 7
3	Name 2	Name 3		Name 5	Name 11
4	Name 3	Name 4		Name 1
5	Name 4	Name 6		Name 11
6	Name 5
7	Name 6
Missing

Cell Formulas
Range	Formula
B2:B5	B2	=FILTER(A2:A7,ISNA(MATCH(A2:A7,D:D,0)),"")
E2:E3	E2	=FILTER(D2:D5,ISNA(MATCH(D2:D5,A:A,0)),"")
Dynamic array formulas.

 

[johnwetherby]

Thats exactly what I mean! Is it case sensitive? What does the A:A and D:D part mean in the formulas? Thanks

 

[johnwetherby]

Also, what happens with duplicates (multiple of the same name in list A)? Ideally I'm hoping that if there are multiple entries of the same name in list A, there needs to be multiple in list B. Is there a way to achieve this?

 

[Peter_SSs]

Is it case sensitive?

Try it.

What does the A:A and D:D part mean in the formulas?

=FILTER(A2:A7,ISNA(MATCH(A2:A7,D:D,0)),"")
D:D simply means column D. So the formula says to look for the A2:A7 values in column and if no match (where #N/A would be returned by the MATCH function) then return the column A value as part of the results.
Similarly, A:A just means column A

Also, what happens with duplicates (multiple of the same name in list A)? Ideally I'm hoping that if there are multiple entries of the same name in list A, there needs to be multiple in list B. Is there a way to achieve this?

Could we have some sample data with the expected results manually filled in so that we can see just what results you want. With your version and operating system I don't think that you will be able to use XL2BB but you should be able to simply copy/paste from your worksheet into your post.