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

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?
 
G

Guest

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
 
S

Scott

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Function in Excel to count and list number of entries of text valuesin a row. 2
Conditional Formatting based on match to external list 1
Frequency of items in a huge range 3
Count frequencies; Pareto of nonumeric values 11
Frequency of date 4
Vlookup using a dropdwn list, check different tables based on drop 2
frequency function and list features 5
How to create a ranked list 2

Top