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!

BTW, here's what it looks like if you don't want to download the spreadsheet.

tag_assignment_image.jpg

edit, nevermind. I can't get the image to appear, and I can't seem to delete the post.

Hi, welcome to the forum

Not really sure what answers you are expecting here, but this formula may help...
Rank without missing numbers...=RANK($H5,$H$5:$H$25,1)+COUNTIF($H$5:H5,H5)-1
where column H contains the data to be ranked

That won't work. Using the countif will just rank the tie scores in the order that they appear on the sheet, not by the players starting tag number.

so add then together?

ok can you update your sample workbook with how you want the answer to look like?

Sure. Here's how it should come out. However I just replaced the formula in the effected cells with the correct number.

That looks pretty much like the 1st table you uploaded? What would your end result look like?

The 1st table was almost right. It's only the ties scores that have incorrect results in the Tag Out column. The image below shows the 3 results that are wrong (indicated by red arrows). The ties corrected column is only there to note what the correct values should have been for the tie scores (circled in red).