Count number of different entries in a column
 

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

Count number of different entries in a column
 

try this

=COUNTIF(A1:A9,"gb")

mike

"andreashermle" wrote:

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

Count number of different entries in a column
 

On Oct 6, 4:12*pm, Mike H wrote:
try this

=COUNTIF(A1:A9,"gb")

mike



"andreashermle" wrote:
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- Hide quoted text -

- 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

Count number of different entries in a column
 

On Tue, 6 Oct 2009 07:01:20 -0700 (PDT), andreashermle
wrote:

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

Count number of different entries in a column
 

Hello Andreas,

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

Regards,
Bernd

Count number of different entries in a column
 

On Oct 6, 5:10*pm, Ron Rosenfeld wrote:
On Tue, 6 Oct 2009 07:01:20 -0700 (PDT), andreashermle
wrote:





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

Count number of different entries in a column
 

On Oct 6, 7:37*pm, Bernd P wrote:
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

Count number of different entries in a column
 

On Tue, 6 Oct 2009 14:17:00 -0700 (PDT), andreas-hermle
wrote:

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