find cells with same value and assign a number to each

**Traymond** · 06-11-2009, 11:44 AM

I use my spreadsheet to keep score during tournaments. when i calculate my leaderboard at the end of the event i list the results first place all the way down until it finishes the list of players. i need to be able find players with the same or equal score and list them as tied for the same place.
another words if i get to the 3rd place and i had 3 players tie for third i need my leaderboard to show them all in 3rd place . currently it would number then 345. i listed below how it should format it. i also attached a file it will make it more clear.

A             B               C

1        john doe        -17
2        jane doe         -9
3        jim doe           -8
3        daffy duck      -8
3       mickey mouse   -8
4        donald duck     -7

**starryknight64** · 06-11-2009, 11:48 AM

I've attached the finished worksheet. Inside, I've just changed the formula in the "Place" column to this (and copied the formula down):

=IF(O10=O11,C10,C10+1)

Enjoy!

**royUK** · 06-11-2009, 12:42 PM

Your post does not comply with Rule 5 of our Forum RULES. We have Seven question forums: Miscellaneous, General, Programming, Worksheet Functions, Charting, Excel 2007 Help and New Users. Please choose the appropriate forum, and post your question in ONLY one forum.

Moved to Functions Forum