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
Bookmarks