Attached is a sample workbook with all the 3166-1 A2 country codes. One sheet is a map and one is a chart with the country code, the generated lat, and the generated long
While is extremely possible I'm not doing something right, there are many many countries that have no generated lat/long. Many are important in some of my other projects, so I generated this simple sample to illustrate the issue.
I'm using 10.0.1 on a Mac
The glaring points to me are China and Australia are not geo-coded.
Any way to edit the generated lat/long tables and add CN and AU? There are 71 countries that aren't working right!