Count number of different entries in a column

[andreashermle]

Dear Experts:

I got a field / column in a table with different values (country
codes):

COUNTRY
ES
EN
FR
FR
DE
EN
US
GB
GB


I now would like to find out how many times the different values have
been entered such as:

ES 4
EN 5
DE 1
GB 7
US 8
etc.

Help is much appreciated. Thank you very much in advance. Regards,
Andreas

 

[Mike H]

try this

=COUNTIF(A1:A9,"gb")

mike

 

[andreas-hermle]

try this

=COUNTIF(A1:A9,"gb")

mike








- Show quoted text -

Dear Mike H:

ok, we are halfway there. Thank you very much in advance. Regrettably
I do not have a unique list of all the different entries in that
country code column, i.e I do not know how many different (unique)
country codes there are in that list. The column has more than 800
rows and has dozens and dozens of different country codes in it. I
would like Excel to first generate me that list of available country
codes (without any duplicates etc.). Is that possible?

Regards, Andreas

 

[Ron Rosenfeld]

Dear Experts:

I got a field / column in a table with different values (country
codes):

COUNTRY
ES
EN
FR
FR
DE
EN
US
GB
GB


I now would like to find out how many times the different values have
been entered such as:

ES 4
EN 5
DE 1
GB 7
US 8
etc.

Help is much appreciated. Thank you very much in advance. Regards,
Andreas

One way would be to use a Pivot Table.

Drag the country codes to the Rows area, and also to the Data area. Be sure it
defaults to "Count" of Country.

Sort and Format to taste.
--ron

 

[Bernd P]

Hello Andreas,

I suggest to use my UDF Lfreq:
http://sulprobil.com/html/lfreq.html

Regards,
Bernd

 

[andreas-hermle]

One way would be to use a Pivot Table.

Drag the country codes to the Rows area, and also to the Data area.  Besure it
defaults to "Count" of Country.

Sort and Format to taste.
--ron- Hide quoted text -

- Show quoted text -

Ron, great, this works and moreover is a quick (built-in) solution.
Thank you very much for your professional help. Regards, Andreas

 

[andreas-hermle]

Hello Andreas,

I suggest to use my UDF Lfreq:http://sulprobil.com/html/lfreq.html

Regards,
Bernd

Dear Bernd,

terrific help. Thank you very much for your superb solution. I really
appreciate it. Regards, Andreas

 

[Ron Rosenfeld]

Ron, great, this works and moreover is a quick (built-in) solution.
Thank you very much for your professional help. Regards, Andreas

Glad to help. Thanks for the feedback.
--ron