Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Counting Various repeating entries
Hi,
I need to create a 'tool' that counts the number of times a particular country appears in a list. The countries are never the same, and the number of entries is never the same, so i need to be able to generate a list of the coutries that appear, and then count the frequency of which they appear. Sorry if this is the wrong forum to post this question. I have tried working on some basic formulas but have come to a standstill. Thanks in advance for your help. Gavin |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Counting Various repeating entries
Assuming the data is in column A.
B1: = A1 B2: =IF(ISERROR(MATCH(0,COUNTIF(B$1:B1,$A$1:$A$20&""), 0)),"", INDEX(IF(ISBLANK($A$1:$A$20),"",$A$1:$A$20),MATCH( 0,COUNTIF(B$1:B1,$A$1:$A$20&""),0))) B2 is an array formula, it should be committed with Ctrl-Shift-Enter, not just Enter. Excel will automatically enclose the formula in braces (curly brackets), do not try to do this manually. When editing the formula, it must again be array-entered. C1: =IF(B1="","",COUNTIF(A:A,B1)) copy B2 and C1 down. -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Gavin" wrote in message oups.com... Hi, I need to create a 'tool' that counts the number of times a particular country appears in a list. The countries are never the same, and the number of entries is never the same, so i need to be able to generate a list of the coutries that appear, and then count the frequency of which they appear. Sorry if this is the wrong forum to post this question. I have tried working on some basic formulas but have come to a standstill. Thanks in advance for your help. Gavin |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting repeating cell values | Excel Worksheet Functions | |||
conditional formatting to group rows with repeating entries | Excel Discussion (Misc queries) | |||
REPEATING TEXT ENTRIES TO COME UP WHEN TYPING FIRST LETTER | New Users to Excel | |||
Counting non-repeating dates | Excel Discussion (Misc queries) | |||
Copying different repeating entries down a column | Excel Discussion (Misc queries) |