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
Any help is much appreciated!
Eric