Thanks to John Bundy, who created an "update" code in the spreadsheet to
enable me to get the correct resulting table.

In the process of "testing" now, but initially appears great.

Terry
"Terry" wrote in message
...
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