Here's a puzzle I could use help solving.

[dcon67]

I tried posting this question a couple of days ago, but I think I made it too confusing by including my attempt at solving it. So here is a simplified version.

We have a list of players. At the start of play each player turns in a tag with a number on it. After the round is over and the scores are recorded, they are re-assigned one of the tags previously turned in based on how they finished. (lowest score gets the lowest tag). In the event of a tie, the next lowest tag goes to the person that started the round with a lower tag number.

Tag_Image_3.jpg

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.

[ChemistB]

Okay,to break ties, I used the tag they turned in as secondary criteria which is what it looks like you did.

So first I created a new column
in F5 copied down
=D5+C5/100
Then I used a combination of SMALL and RANK like so

=SMALL($C$5:$C$14,RANK(F5,$F$5:$F$14,1))
See attachment. Does that work for you?

[dcon67]

That's PERFECT. Thank you so much!!!