Need a ranking with only unique names attached to the values.

Hello everyone,

I'm making an excel file where I keep track of the scoring in a little competition me and my friends do with betting on sports.

However, I got a little problem trying to automate my ranking.

Naamloos.jpg

As you can see in the image, when there is a duplicate score, the name stays the same for every other same value (Joris).
The formula I use (also as seen in the image) just takes the first name it comes across (from left to right) and keeps using that one. But I need it to ignore the name Joris the second time, and ignore Joris AND Tim the third time, so that every score/rank (even if the scores are a draw) has a unique name attached to it.

Any ideas on how I can accomplish this?

Thanks a lot!

Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

Or you can play around with adding rows/columns to your data so they all be unique.
Look this example few minutes ago: http://www.excelforum.com/excel-gene...ax-values.html