COUNTING THE NUMBER OF A CERTAIN TEXT IN A COLUMN

[jbyrne]

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.

 

[Aladin Akyurek]

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)

 

[jbyrne]

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...

 

[Aladin Akyurek]

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?

 

[Dave Hawley]

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.

 

[jbyrne]

THANKS DAVE AND ALADIN,

THE PIVOT TABLE WORKED GREAT!!!!