Hello guys,

I just joined and I am very keen to get to know you.

I have a slight problem with finding the right formula. Please help me if you can:

I have a spreadsheet with a list of countries in column "B". I want to separate them by different tiers e.g. if column B equals to let's say UK, Turkey, Macedonia, Bulgaria to have a text "priority" in column C and also if i have Portugal, Greece and Spain in column "B" to have a text "comm" and if i have a county which does not match the ones that i listed to have "all others"?

Many thanks in advance!

George