Results 1 to 14 of 14

Help with breaking ties

Threaded View

  1. #1
    Registered User
    Join Date
    10-08-2014
    Location
    Greenfield, MA
    MS-Off Ver
    Office 2013
    Posts
    19

    Help with breaking ties

    Okay....here's my problem.

    Tag_Assignment.xlsx

    Here we have a list of players. At the start of play each player turns in a tag with a number on it and it gets recorded. After the round is over and the scores are recorded, they get re-assigned a new tag based on how they finished. (lowest score gets the lowest tag). I've made a small spreadsheet (attached) to show I'm currently trying to do it. I've used the rank function to rank the scores, as well as the tags, and then use index/match to pair the lowest score to the lowest tag and output the result. (Score Rank and Tag Rank columns would eventually be hidden as there's no need to see them once worksheet is functioning correctly.)

    The problem are ties. Ties are supposed to be broken by the lowest starting tag that the player had at the start of play. I've manually put what the corrected results should be on the right under the heading "Ties corrected".

    Any ideas on how to accomplish this? Also, I can't use macros or array formulas since I need to be able export this to Numbers for use on an iPad/iPhone.

    Thanks in advance!
    Last edited by dcon67; 10-08-2014 at 01:17 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Problems Breaking Ties In Rank Function
    By windme in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 06-23-2014, 12:59 AM
  2. Breaking ties using vlookup, if, etc.
    By RJR34 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-02-2013, 10:21 PM
  3. [SOLVED] RANK - Breaking Ties
    By sachinattri in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 05-28-2013, 04:32 AM
  4. Breaking ties with rank alphabetically
    By ktms in forum Excel General
    Replies: 7
    Last Post: 11-03-2011, 07:06 PM
  5. Breaking Ties in Ranking
    By Zainuddin Zakaria in forum Excel General
    Replies: 4
    Last Post: 03-05-2006, 04:00 AM

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