Hi,

I have a golf spreadsheet that calculates stableford points based on
someones score on a hole, the index of that hole and the players
handicap. It works fine, calculating up to 50 players points totals. Now
I would like to calculate the best points total for the first 9 holes.

My spreadsheet is as follows:

ColA ColB ColC ColD ... ColI
H1Score H2pts H2Score H2pts ... Pts9total
..
..
..

Of course using the Max function for ColI would give me the highest
score in that column but what if there are 2 people with the same points?

So now to my question, how can I determine the highest points total in
ColI and if there is more than one row with the same (highest) points?
Also I would need to find out the rows themselves so I can do another
calculation.

Thanks in advance,
Shay