Hello group

I have a spreadsheet that calculates the players Position, Total score,
Played games, and Number of wins, from a MAIN sheet.

Positions Names Total Scores Played Wins
1st Crossland A. 129 8 2
2nd Phillipson G. 124 9 1
3rd Burgess. E 123 9 1
4th Whitehead. J 113 9 1
5th Hand P. 105 9 0
6th Mawer. A 104 7 0
7th Burman. P 96 6 0
8th Ellis. J. Mr 94 9 0
9th Ellis. J. Mr 94 9 0


I have run into a snag where further down this table in 8th & 9th places it
has created an EXACT duplicate Name and Played games, but correct equal
scores. It is the 9th place that is in error.

I cannot see errors from the used functions below. Can you ??

This is a formula from this group(best 25 scores 13/2/08) on a linked MAIN
sheet: (best 6 scores of a player and summed), in this case I use just 6
score highest.
=IF(AND(ISNUMBER(M16),M16=6),SUM(LARGE(A16:L16,RO W($A$1:$A$6))),IF(ISNUMBER(M16),"",""))
.... this is entered as an array.

Name of first place:
=INDEX(Main!$A$4:$A$69,MATCH(D11,Main!$P$4:$P$69,0 ))

Total score for that person:
=LARGE(Main!$P$4:$P$69,ROW(1:1))

Games played:
=LOOKUP(C4,Main!$A$4:$A$69,Main!$M$4:$M$69)

Number of wins:
=LOOKUP(C4,Main!$A$4:$A$69,Main!$O$4:$O$69)

Again I find it difficult to explain fully, so don't be too hard...I will
give further required info as requested.

TIA

Terry