Apr 18 2022 10:39 PM
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 have the names of all countries in the world, but I want to get only the names of African countries from this list. Is there a formula for doing this? A function maybe to "call out" the country names? FYI, I see suggestions that I can use VLOOKUP, but I have tried, and it does not work. Or maybe I am using it wrongly.
Thanks!
Apr 19 2022 01:13 AM
Solution@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?
Apr 19 2022 03:46 AM
@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.
Apr 19 2022 04:26 AM
Apr 19 2022 04:36 AM - edited Apr 19 2022 04:37 AM
@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.
Apr 20 2022 01:18 AM
Apr 20 2022 01:19 AM
Jun 21 2022 02:28 PM
Apr 19 2022 01:13 AM
Solution@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?