+ Reply to Thread
Results 1 to 2 of 2

populating list with unique values (revised)

  1. #1
    Registered User
    Join Date
    07-19-2007
    Posts
    50

    populating list with unique values (revised)

    I posted earlier but omitted a critical detail. If i have multiple series of lists with repeating values, how do i create a list that automatically populates the list of unique values and totals them according to an attribute (month) of the series(s): see attached file
    thanks
    Attached Images Attached Images

  2. #2
    Cheeky Forum Moderator Ron Coderre's Avatar
    Join Date
    03-22-2005
    Location
    Boston, Massachusetts
    MS-Off Ver
    2013, 2016, O365
    Posts
    6,996

    populating list with unique values (revised)

    Your data will be much easier to work with if you separate Data Storage from Data Presentation.....

    With a structure like this:
    GAME.........DATE........PLAYER.........HITS
    Game1........1-Jan.......John.............1
    Game1........1-Jan.......James...........2
    Game1........1-Jan.......Tom.............1

    You can then....
    Create a Pivot Table that resembles the first view in your posted jpg

    And....you can use another Pivot Table to calculate the second view in that jpg. (Pivot Tables can group dates by month)

    Is that something you can work with?

    (Post back if you have more questions)

    Regards,

    Ron
    Microsoft MVP (Excel)

+ 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