Grouping Countries Into Continents?

whynotea

New member
Joined
Jul 28, 2015
Messages
2
Reaction score
0
Points
0
Hi - I have an excel list of about 1800 individuals who are from countries all over the world, and need to group them into specific categories. Is this possible using Excel? For example, I would like for the list to show all of the people from Belgium, Germany, Switzerland, etc. as 'Europe' and all of the people from China, Japan, Nepal, etc. as 'Asia' and all from countries like Afghanistan, Ethiopia, Liberia, etc. as 'Other.' Is this possible? If so, what are the functions that I need to use and how do I set it up? I think I uploaded a test file to this post but am not sure I did it correctly (file only has first names).

Any help is much appreciated!

Eric
 

Attachments

  • July 2015 TEST RAW DATA - 7.23.15.xlsx
    41.2 KB · Views: 1,627
On another sheet build yourself a lookup table where column A is the unique Countries of Citizenship, and column B is the region. Then in cell C2 of your "201572432810" sheet, use this formula:

Code:
=VLOOKUP(B2,'Lookup sheet name'!$A:$B,2,0)

Copy/Autofill down.

Cheers,
 
Thank-you CheshireCat - you are making me look like a genius to my team!

Eric
 
Back
Top