+ Reply to Thread
Results 1 to 4 of 4

Competition Results order

  1. #1
    Registered User
    Join Date
    06-15-2013
    Location
    Drakes Broughton
    MS-Off Ver
    Excel 2010
    Posts
    2

    Cool Competition Results order

    I would be erternally gratefull if someone could assist me with the following problem.

    I am running a gymnastic competition for children competing in different age groups. and i want to be able to enter there scores and a finishing order be displayed. I have got the final score values to display in the correct order however if there is a duplicate score in any of the catagories i get an error. and i can't get the corosponding name to be printed next to it, i think i am having a circular calc somewhere in the formula.

    Bit new to this excel thing I have attached the file i am working on with the highlighted areas being the issue.

    Many thanks to any clever person who comes to my aide.

    Cheers
    Attached Files Attached Files
    Last edited by firegodcom; 06-15-2013 at 07:01 PM.

  2. #2
    Forum Guru shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Competition Results order

    If you made one single list with columns for name, level, session, event scores, and total score, all you'd need to do is sort the list by session, level and score.
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Registered User
    Join Date
    06-15-2013
    Location
    Drakes Broughton
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: Competition Results order

    I think I have solved. good old shift ctrl and enter. and small error on one colomn.

    Many thanks for those who viewed.

    attached completed file in case anyone is looking for something similar
    Attached Files Attached Files

  4. #4
    Forum Guru shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Competition Results order

    Here's what I was talking about. The scores are random, so the pivots will change each time you refresh the tables. The pivots could be on separate sheets, and you can have one for each session and level.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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