I'm a newbie to excel, sorry if I don't make sense.
I'm putting together a golf tournament spreadsheet. Players come in with a tag, ranking them from 1 - 100 which is given to the tournament director. After the tournament the director enters player's scores and I've got the spreadsheet ranking their names according to score. Now, I need it to assign a new tag number, of those that were given to the director that day, to each player, with the player who came in with the better tag receiving the better tag in the case of a tie. I have gotten it to assign the tags, but when there is a tie it's assigning the same tag to all who tied. How can I fix this? Here is what I've got for the function currently: =VLOOKUP(A4,$B$4:$C$16,2,FALSE) A4 is the rank of the individial, B4 - B16 is the rank of the tag and C4 - C16 is the tag number.
Bookmarks