+ Reply to Thread
Results 1 to 3 of 3

Counters

  1. #1
    Paul
    Guest

    Counters


    How can I setup a counter to count the number of times a
    word appears in one column. The column I have contains
    city names and I'd like another column to display the
    number of times the City name appears.

    Example...

    Column 1 Column2 Column 3

    Liverpool Liverpool= 3
    Liverpool London= 2
    Liverpool Edinburgh= 4
    London
    London
    Edinburgh
    Edinburgh
    Edinburgh
    Edinburgh

    Any help would be muchly appreciated

  2. #2
    JE McGimpsey
    Guest

    Re: Counters

    A Pivot Table would be the most flexible way, and it's easy.

    http://peltiertech.com/Excel/Pivots/pivotstart.htm

    However, if you want to use Worksheet functions, enter your city names
    in B1:Bx, then use:

    C1: =COUNTIF(A:A,B1)

    and copy down as far as required.


    In article <1f6401c51037$bdef9d10$a601280a@phx.gbl>,
    "Paul" <pohanlon1980@hotmail.com> wrote:

    >
    > How can I setup a counter to count the number of times a
    > word appears in one column. The column I have contains
    > city names and I'd like another column to display the
    > number of times the City name appears.
    >
    > Example...
    >
    > Column 1 Column2 Column 3
    >
    > Liverpool Liverpool= 3
    > Liverpool London= 2
    > Liverpool Edinburgh= 4
    > London
    > London
    > Edinburgh
    > Edinburgh
    > Edinburgh
    > Edinburgh
    >
    > Any help would be muchly appreciated


  3. #3
    Guest

    Re: Counters


    Thanks man, worked a treat

    >-----Original Message-----
    >A Pivot Table would be the most flexible way, and it's

    easy.
    >
    > http://peltiertech.com/Excel/Pivots/pivotstart.htm
    >
    >However, if you want to use Worksheet functions, enter

    your city names
    >in B1:Bx, then use:
    >
    >C1: =COUNTIF(A:A,B1)
    >
    >and copy down as far as required.
    >
    >
    >In article <1f6401c51037$bdef9d10$a601280a@phx.gbl>,
    > "Paul" <pohanlon1980@hotmail.com> wrote:
    >
    >>
    >> How can I setup a counter to count the number of times

    a
    >> word appears in one column. The column I have contains
    >> city names and I'd like another column to display the
    >> number of times the City name appears.
    >>
    >> Example...
    >>
    >> Column 1 Column2 Column 3
    >>
    >> Liverpool Liverpool= 3
    >> Liverpool London= 2
    >> Liverpool Edinburgh= 4
    >> London
    >> London
    >> Edinburgh
    >> Edinburgh
    >> Edinburgh
    >> Edinburgh
    >>
    >> Any help would be muchly appreciated

    >.
    >


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1