Quote Originally Posted by ChemistB View Post
Okay, so you only want 1 person to have the #1 position? How do you choose Luke and not Jim, Sang-Moon or Robert since they have the same scores?
The answer to your question is:

In all golf tournaments if 2 or more players are tied after the regulation 4 rounds of golf there is a playoff/tiebreaker held immediately all players are available to do so. These players will continue to play subsequent holes until one player scores a better result than the others. This is how Mr Donald came to win this particular tournament he defeated Furyk,Bae and Garrigus in a playoff. Although this fact will not be reflected in this sheet.

Exactly. Although I have worked it around using the formula you suggested. I put 1 manually for the first position and then using the helping column, used the following formula starting from row number 3 =RANK(J2, $J$2:$J$146, 1)+1. And perfect, it generates the result that I wanted. Although it was not fully automated as I wanted, but it is still working and I am very grateful to you for that. Reps added

Thanks.