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