Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Count number of different entries in a column
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to count the number of unique entries in a filtered column | Excel Discussion (Misc queries) | |||
Count, number of entries of a particular month. | Excel Worksheet Functions | |||
Count entries in one column based on values in another column | Excel Worksheet Functions | |||
How can I count the number of entries in a column? | New Users to Excel | |||
Count number of different entries? | Excel Worksheet Functions |