Filter list that not contain some values

[Omer_K]

Hi, everyone,
I have a list of countries (column A) and in column B there is a list of countries that should not be on the list - the list in column B will update over time,
I would like to know how I can create a list of countries without the countries that should not appear (as in column D)
It is only important for me to say - that the list of countries that are not supposed to appear is going to be long..
Thank You

All Country​	Countries that should not be on the list​		List Of New Country​
Australia​	Croatia​		Australia​
Bahamas​	Egypt​		Bahamas​
Belgium​			Belgium​
Canada​			Canada​
Chile​			Chile​
Croatia​			Cuba​
Cuba​			Congo​
Congo​			Ecuador​
Ecuador​			Estonia​
Egypt​			Fiji​
Estonia​			Greece​
Fiji​
Greece​

 

[Fluff]

How about

=FILTER(A2:A1000,(A2:A1000<>"")*(ISNA(MATCH(A2:A1000,B2:B1000,0))))

 

[Omer_K]

It works perfectly!!
Thank you very much Fluff

 

[Fluff]

You're welcome & thanks for the feedback.