+ Reply to Thread
Results 1 to 5 of 5

Video Game Leaderboard Auto Query

  1. #1
    Registered User
    Join Date
    10-11-2012
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    3

    Unhappy Video Game Leaderboard Auto Query

    We have a gaming league at our store and I'd like to display the top scorers for a certain time period in a separate sheet.

    My first sheet in the workbook pulls data from an online submission form. It looks like this:

    Timestamp 4 Digits Last Name Kills Deaths
    12/20/2012 23:48:35 6464 DUNNIGAN 32 12
    12/20/2012 23:48:54 6464 DUNNIGAN 18 2
    12/20/2012 23:49:06 1234 WATT 27 4
    12/20/2012 23:49:19 1234 WATT 31 20
    12/20/2012 23:49:34 4321 BURTON 12 1
    12/20/2012 23:49:48 4321 BURTON 34 16

    On the second sheet I need to show only submissions that happened today, but I also need to combine duplicate names and add scores together. The sheet will also need to display by most to least kills. So it will need to look like this:

    1234 WATT 58 24
    6464 DUNNIGAN 50 14
    4321 BURTON 46 17

    The third sheet will do the same thing but in the timestamp range of the last 7 days.

    The fourth sheet, the last 30 days.

    The fifth sheet, of all time.

    I've tried for many hours to piece together the formulas myself and I just can't make it happen, HELP!

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,443

    Re: Video Game Leaderboard Auto Query

    Perhaps use a Pivot Table grouping by days, weeks, etc and use the manual filter i the required field to display the 10 ( or another number) fields

  3. #3
    Registered User
    Join Date
    10-11-2012
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Video Game Leaderboard Auto Query

    I'm using Google Docs so I can only use formulas for this solution. Not VBA or pivot tables.

  4. #4
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,443

    Re: Video Game Leaderboard Auto Query

    Then perhaps visit a Google Docs forum and in the future be so kind as to warn the members you are using that application.
    You make people loose their time trying to help you. It's not because these forums are free that some courtesy is out of place.

  5. #5
    Registered User
    Join Date
    10-11-2012
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Video Game Leaderboard Auto Query

    No worries, should have included that in the original post. The formulas are all the same and the Excel community is much more active than the Google Docs community, so I figured I would check here for help! Thanks.

+ 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