Hi everybody

I receive weekly big Data with land codes, e.g.
A B
1 D code should write EU here
2 CH also EU
3 VE code should write LA (Latin America)
4 AR also LA
5 BR also LA
6 US code shoud write NA (North America)
7 CDN also NA
etc. ... ...

Thus I can apply a filter then, to make my data more readable and grouped by
continent.
I hope a Guru of yours here can be helful to me and shows me ther formulas
or code for this task.

Many thanks in advance, Mick