Tables
Tables
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 6 of 6

Thread: Tables

  1. #1
    New Member
    Join Date
    Apr 2002
    Posts
    43
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    If you have a column of names (some names are the same) how do you produce a seperate table that produces a column with the names (without repetition) and then a second column showing the results of how often those names occur?

  2. #2
    MrExcel MVP lenze's Avatar
    Join Date
    Feb 2002
    Location
    Helena, MT
    Posts
    13,690
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    You can use advanced filter, unique records only option , filter to new location for to produce a list of unique names. Then use COUNTIF to count each name in the first list.

  3. #3
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Create a PivotTable like the one show below...

    ******>
    Count of Name
    NameTotal
    Curly1
    Larry3
    Moe2
    Grand Total6



    [ This Message was edited by: Mark W. on 2002-04-05 07:30 ]

  4. #4
    New Member
    Join Date
    Apr 2002
    Posts
    43
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Thanks Ienez but I can't seem to get the COUNTIF to work.

    Mark W. I did this before but I don't want a grand total, can I get rid of that?

  5. #5
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-04-05 07:37, Frankie needs HELP wrote:

    Mark W. I did this before but I don't want a grand total, can I get rid of that?
    Right-click the PivotTable, choose Options... from the popup menu, and uncheck "Grand totals for columns".

  6. #6
    New Member
    Join Date
    Apr 2002
    Posts
    43
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    Thank you, thank you, thank you.

    I've got both ways working now.

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
  •  

 

 
DMCA.com