Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 6 of 6

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

  1. #1
    Board Regular
    Join Date
    Feb 2002
    Posts
    177
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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. #2
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    84,006
    Post Thanks / Like
    Mentioned
    37 Post(s)
    Tagged
    7 Thread(s)

    Default

    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. #3
    Board Regular
    Join Date
    Feb 2002
    Posts
    177
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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. #4
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    84,006
    Post Thanks / Like
    Mentioned
    37 Post(s)
    Tagged
    7 Thread(s)

    Default

    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. #5
    Rest in Peace
    Join Date
    Feb 2002
    Posts
    1,582
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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.


  6. #6
    Board Regular
    Join Date
    Feb 2002
    Posts
    177
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    THANKS DAVE AND ALADIN,

    THE PIVOT TABLE WORKED GREAT!!!!

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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