Thanks:  0
Likes:  0

# Thread: COUNTING THE NUMBER OF A CERTAIN TEXT IN A COLUMN

1. I have a column of dates listed as text as the following, 20020402 standing for April 4 2002. I would like to count in the column next to the date column,how many of that date there are.

For example
column A column B
20020402 1
20020402 2
20020402 3
20020403 1
20020403 2
20020404 1
20020404 2
20020404 3
20020404 4

Any help would be greatly appreciated.

2. On 2002-04-02 10:49, jbyrne wrote:
I have a column of dates listed as text as the following, 20020402 standing for April 4 2002. I would like to count in the column next to the date column,how many of that date there are.

For example
column A column B
20020402 1
20020402 2
20020402 3
20020403 1
20020403 2
20020404 1
20020404 2
20020404 3
20020404 4

Any help would be greatly appreciated.
In B1 enter and copy down:

=COUNTIF(\$A\$1:A1,A1)

3. Thanks....It worked great!. Is there a way I can put the results on a seperate sheet. For example,

COLUMN A COLUMN B
TOTAL FOR 20020411 10654
TOTAL FOR 20020415 165

etc...

4. On 2002-04-02 19:19, jbyrne wrote:
Thanks....It worked great!. Is there a way I can put the results on a seperate sheet. For example,

COLUMN A COLUMN B
TOTAL FOR 20020411 10654
TOTAL FOR 20020415 165

etc...
Do you mean by "TOTAL FOR 20020411" how many times 20020411 occurs in the data area or something else that must be totaled?

5. Hi

If you ensure your data has a heading, select your data and go to Data>Pivot Table you can drag this one field to both the "Data" area and the "Row" area. This way you will get a nice table set up for you, you could even use a dymamic range so it updates automatically.

If you would like me to do this for you email me and I'll set it up for you.

THE PIVOT TABLE WORKED GREAT!!!!

## User Tag List

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•