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
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 |