Results 1 to 5 of 5
  1. #1
    Lounger
    Join Date
    Dec 2007
    Location
    Sacramento, California, USA
    Posts
    30
    Thanks
    0
    Thanked 0 Times in 0 Posts

    look up and count (excel 2003)

    I have a column with names in it. I want to count how many times each name appears and put each count in a separate cell.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: look up and count (excel 2003)

    The easiest way is to create a pivot table based on the data.
    You need to have a column heading (field name) above the data for this.
    Select a cell in the data.
    Select Data | Pivot Table and Pivot Chart Report.
    Click Next.
    Excel should automatically select the entire table, including the column heading.
    Click Next.
    Click Layout.
    Drag the field name to the Row area and also to the Data area.
    Click OK.
    Specify a target, then click Finish.

  3. #3
    Lounger
    Join Date
    Dec 2007
    Location
    Sacramento, California, USA
    Posts
    30
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: look up and count (excel 2003)

    Thank you.

    Is there a way for a pivot table to be automatically updated when new data is put in the spreadsheet?

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: look up and count (excel 2003)

    You could use code in the Worksheet_Change event of the sheet containing the data - see <post:=600,311>post 600,311</post:>.

  5. #5
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: look up and count (excel 2003)

    If you are going to refresh the pivot with additional data in later rows, in addition to Hans' suggestion of the worksheet change macro, you should consider Dynamic Names so that the Piviot table source expands as new data is added...

    Steve

Posting Permissions

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