I need a formula that can add all the countries with that is in a column.
Example:
in Sheet ‘Export’ I have below countries of origin:
And in other sheet I need to add all the countries of origin and change the name from RO to Romania or SK to Slovakia, etc…
What I have until now is the formula: =TEXTJOIN(“, “,TRUE, IF(left(Export!Q1,2) = “RO” , “ROMANIA”, IF(left(Export!Q1,2) = “US” , “USA”, IF(left(Export!Q1,2) = “PT” , “PORTUGALIA”, IF(left(Export!Q1,2) = “FR” , “FRANTA”, IF(LEFT(Export!Q1,2) = “SK” , “SLOVACIA”))))))
But is not working. It only add the first country found, not all of them.
Can anyone help?
Thank you
