Forum Discussion
Need help on how to extract specific country names based on region
GITKE Excel doesn't know which continent/region each country in your list belongs to. So if you haven't added a column for the continent/region as well. there is no way to extract a list of African counties by their name only. If you have the continent/region with each country, you can put a filter on the table for the Region column or use the FILTER function to extract countries by region. Which Excel version are you using?
GITKE Excel doesn't know which continent/region each country in your list belongs to. So if you haven't added a column for the continent/region as well. there is no way to extract a list of African counties by their name only. If you have the continent/region with each country, you can put a filter on the table for the Region column or use the FILTER function to extract countries by region. Which Excel version are you using?
Riny_van_Eekelen Aha! that makes a lot of sense. The data came without regions added. The problem might be doing that manually as well.
I am using professional plus 2016.
GITKE There are many links on line that indicate countries by region/continent. Here's one of them.
https://www.clearias.com/countries-world-listed-continent/
With a little bit of copying and pasting, you can create a two column table.
- This helps a tonne. Thanks again
