Posted to microsoft.public.excel.programming

andreashermle andreashermle is offline

external usenet poster

Posts: 123

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to count the number of unique entries in a filtered column	learnlearn52	Excel Discussion (Misc queries)	4	May 13th 09 05:56 PM
Count, number of entries of a particular month.	Danny	Excel Worksheet Functions	4	May 21st 07 10:05 PM
Count entries in one column based on values in another column	Kurt	Excel Worksheet Functions	7	January 10th 07 09:29 PM
How can I count the number of entries in a column?	Dave Hacker	New Users to Excel	3	November 24th 05 08:48 PM
Count number of different entries?	DTTODGG	Excel Worksheet Functions	2	November 10th 05 01:05 AM

All times are GMT +1. The time now is 12:34 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us