Results 1 to 19 of 19

Finding Nth ranking value based on multiple criteria

Threaded View

  1. #1
    Valued Forum Contributor scaffdog845's Avatar
    Join Date
    02-01-2008
    Location
    Aston, PA. USA.
    MS-Off Ver
    Microsoft 365
    Posts
    375

    Finding Nth ranking value based on multiple criteria

    This one has got me stuck. I'm trying to score multiple dual track meets while 3 teams compete simultaneously. In the scoring the 1st and 2nd place positions for each dual meet must come from the 1st heat only. 3rd thru 6th place can come from any of the heats. I realize that there will probably be a different formula for 1st/2nd and 3rd-6th.

    I've attached a small sample worksheet with the desired results highlighted in yellow with an explanation of the results below the highlighted cells.
    Attached Files Attached Files
    Last edited by scaffdog845; 04-26-2013 at 10:12 AM. Reason: Notes in original attachment were incorrect. Changed notes and reattached new file
    Click here to read the Forum Rules
    Whatever it is in life you decide to go after, go after with great ferocity.

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