How do I count the frequency of items in a non-numeric list?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a list of employees (in Excel 2002) who are working in many different
countries. I want to calculate how many are in each country. How do I do
this?
 
I was hoping there was a formula (like a histogram) that would count the
countries so I wouldn't have to enter each country name individually into a
formula. I would only need to count the data in one column (the country
column) since the countries are entered multiple times (one line per
employee). (e.g., something that would count 4 occurences of Canada, 2 of
Belgium etc in this one column). Unfortunately, a histogram won't count
non-numeric text. Any ideas? RAR
 
You could use a PivotTable, putting the country on the left side and
just having a count for the actual data.

Alternatively, you could use the advanced filter
(Data->Filter->Advanced Filter) to generate a static list of each
individual country, and then use a COUNTIF() on your full list for each
country. To use the advanced filter, specify the data range to be
just the column with the country names, make sure to choose Copy To
Another Location and specify the location, and also check Unique
Records Only button.

Scott
 
Back
Top