Filter info from 2 columns

[jandak]

I need a hint is solving Excel task. I have two columns with data (let's say column a contains a list of people I have met in May; column b has a list of people I am planning to meet in June).
Is there a function in Excel which will compare both columns and give me a list of people which I have met in May but which are not included in list of planned meetings in June and show results in column C?
Many thanks in advance,

 

[Aladin Akyurek]

Just tried to reverse it in order to have also list of names which were added in June but something didnt worked out.

in c1 cse:

=SUM(IF(1-ISNUMBER(MATCH(ThisMonth;LastMonth;0));1))

in c2 cse:

=IF(ROWS(C$2:C2)<=C$1;INDEX(LastMonth;SMALL(IF(ThisMonth<>"";
IF(1-ISNUMBER(MATCH(ThisMonth;LastMonth;0));Ivec2));ROWS(C$2:C2)));"")

where Ivec2:
=ROW(ThisMonth)-ROW(INDEX(ThisMonth;1;1))+1

as a result i have a list of names corresponding to new names in June(ThisMonth) but from list of May(LastMonth).
for example, new name is in cell b4(Deniz) but in list appears name from a4(dan).

Row\Col	A​	B​	C​
1​	may	june	1​
2​	jon	jon	deniz
3​	john
4​	dan	deniz
5​	damon	dave
6​	lara
7​	dave

A2:A7 >> LastMonth

B2:B5 >> ThisMonth

C1, cse:

=SUM(IF(ThisMonth<>"",IF(1-ISNUMBER(MATCH(ThisMonth,LastMonth,0)),1)))

C2, cse and copy down:

=IF(ROWS(C$2:C2)<=C$1,INDEX(ThisMonth,SMALL(IF(ThisMonth<>"",
    IF(1-ISNUMBER(MATCH(ThisMonth,LastMonth,0)),
    ROW(ThisMonth)-ROW(INDEX(ThisMonth,1,1))+1)),
    ROWS(C$2:C2))),"")