Indicating mismatches in 2 columns

[Nare91]

I have 2 columns, first one is the IDs of students for Q1, the second one is the IDs of students for Q2. In the Q2 new students were accepted and some students dropped, so there is a mismatch in the list of IDs. I need a function that will indicate those IDs that are present in column A but are not included in Column B and vise versa.

Thank you!

 

[konew1]

Try this\\

Excel Workbook
	A	B	C	D
1	Q1	Q2	Status of Q1 students	Status of Q2 students
2	Student 1	Student 2	dropped	returned
3	Student 2	Student 3	returned	returned
4	Student 3	Student 4	returned	returned
5	Student 4	new 1	returned	new
6	Student 5	Student 6	returned	returned
7	Student 6	Student 7	returned	returned
8	Student 7	new 2	returned	new
9	Student 8	new3	dropped	new
10	Student 9	Student 5	dropped	returned
Sheet7

 

[Nare91]

Thank you very much, this is what I was looking for

 

[konew1]

happy to help