Forum Discussion
Solved
Need help on how to extract specific country names based on region
Hey there! Beginner Excel user here. So, I have a list of several countries in a column, and I just want to extract specific countries to a different column, without doing it manually. Basically, I...
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?
Thanks for the suggestion, Sergei.