Sharepoint 2010 - I have a country lookup column wherein multiple values can be selected and is linked to another column (Region column) linked to another list. As it is the Region duplicates when for example a user selects 2 countries from the Africa Region.
Example: When the user selects multiple african countries in the Country Column - Algeria, Angola, Zimbabwe.
The Region Column displays in the view - Africa, Africa, Africa.
In this case I would like that the Region shows Africa only once.
I do not know Jvascript well, but I have seen on the web that I can use the CEWB for this. Does anyone have a javascript or a calculated column formula that I can use to show from the view the unique values of the Region column? I cannot use the Group by for the OOT coz it is a lookup column.
Thank you
