Hi,
For this one, I'm working online in Teams (as the function is not available in my Excel 2016). Desired result is in the clip below for Spain
First column is the result of the INDEX/MATCH type of formula and that's the crux of the story.
Second column is essentially a helper column as I tried different methods to convert the output from column A into the format accepted by Data=>Convert to Geography functionality in Teams. So far, I haven't found a way to do that (formatting, =A2, =TEXT(A2), =TEXTJOIN...), so the entry in B2 is currently hardcoded just to show what I need.
Third column is the final desired output; as long as I have second column sorted I will arrange for that...
Any hint is appreciated on 2nd column.
For this one, I'm working online in Teams (as the function is not available in my Excel 2016). Desired result is in the clip below for Spain
First column is the result of the INDEX/MATCH type of formula and that's the crux of the story.
Second column is essentially a helper column as I tried different methods to convert the output from column A into the format accepted by Data=>Convert to Geography functionality in Teams. So far, I haven't found a way to do that (formatting, =A2, =TEXT(A2), =TEXTJOIN...), so the entry in B2 is currently hardcoded just to show what I need.
Third column is the final desired output; as long as I have second column sorted I will arrange for that...
Any hint is appreciated on 2nd column.