hello, this is my first post & i'm a total beginner, so please be kind...
i tried the forum search but didn't find a solution to my problem.
i have a pretty large database (yeah, i know i probably shouldn't use excel for stuff like that, but i don't have a lot of software) of persons with their names in column A and their home country in column B. what i would like to have is
1) a count of instances of all the countries that appear in column B,
which should ideally look like this:
argentina | 16
australia | 25
austria | 7
belgium | 11
etc.
2) a ranking and a diagram of all the countries with their respective values.
i think i know how to do the second part (it should be in "analysis-functions", right?), so i'd be happy if someone could help me with item 1).
thank you very much in advance
a.
i tried the forum search but didn't find a solution to my problem.
i have a pretty large database (yeah, i know i probably shouldn't use excel for stuff like that, but i don't have a lot of software) of persons with their names in column A and their home country in column B. what i would like to have is
1) a count of instances of all the countries that appear in column B,
which should ideally look like this:
argentina | 16
australia | 25
austria | 7
belgium | 11
etc.
2) a ranking and a diagram of all the countries with their respective values.
i think i know how to do the second part (it should be in "analysis-functions", right?), so i'd be happy if someone could help me with item 1).
thank you very much in advance
a.