scores posted on 'games' sheet, sent to 'matches & games' sheet, find winner, ...

I can't figure out what you are doing, but you might want to look up INDEX. The syntax for index is = INDEX(This Range, This row,This Column). You are apparently using max to find the winning score. You can use MATCH to find out which row it is on (Match will only find the first occurrence) and you should know what column has the name.

Hi

Welcome to the forum.

Games sheet
Total Matches
Cell AR10

Formula:

=COUNTIFS($D$54:$AE$67,$AP10,$J$54:$AK$67,1)

Copy down

Total Scores
Cell AR27

Formula:

=SUM(IFERROR(INDEX($J$27:$J$40,MATCH($AP29,$D$27:$D$40,0)),0),IFERROR(INDEX($S$27:$S$40,MATCH($AP29,$M$27:$M$40,0)),0),IFERROR(INDEX($AB$27:$AB$40,MATCH($AP29,$V$27:$V$40,0)),0),IFERROR(INDEX($AK$27:$AK$40,MATCH($AP29,$AE$27:$AE$40,0)),0))

Copy down

Matches Rank
Cell AU10

Formula:

=RANK(AR10,$AR$10:$AR$20)&"-"&COUNTIF($AR$10:AR10,AR10)

Copy down
Cell AU7

Formula:

=MAX(AR10:AR20)

Cell AT10

Formula:

=IF(AR10=AU$7,1,"")

Copy down
Cell AT7

Formula:

=SUM(AT10:AT20)

Same as Score Rank by change number to 29:39

Matches & Scores sheet

Matches Winner
O24

Formula:

=SUBSTITUTE(TRIM(IFERROR(INDEX(Games!$AP$10:AP$20,MATCH(ROWS($A$1:A1)&"-1",Games!$AU$10:AU$20,0))&" "," ")&IFERROR(INDEX(Games!$AP$10:AP$20,MATCH(ROWS($A$1:A1)&"-2",Games!$AU$10:AU$20,0))&" "," ")&IFERROR(INDEX(Games!$AP$10:AP$20,MATCH(ROWS($A$1:A1)&"-3",Games!$AU$10:AU$20,0))&" "," ")&IFERROR(INDEX(Games!$AP$10:AP$20,MATCH(ROWS($A$1:A1)&"-4",Games!$AU$10:AU$20,0))&" "," ")&IFERROR(INDEX(Games!$AP$10:AP$20,MATCH(ROWS($A$1:A1)&"-5",Games!$AU$10:AU$20,0))," "))," "," & ")]

T24

Formula:

=IF(Games!AT7>1,"TIE","")

Same as Scores Winner by change to 29:39.

This up to 5 players tie? Should be plenty!

See the files

all the best

Hi micope21,

After being a little mindboggled, I finally saw how it worked. The 'matches' function didn't work at first, because you sent it to the lower set of cells for the names, but (of course) I neglected to put the names down there. So, I redirected to the names above and it worked! Thank you!

However, I'm still confused. Is there a function called 'dummy', or does that refer to me? Rightfully so. If it really would find the 'winner' or 'tie', I'd like to figure how to do that. So far, too dense to figure it out.

Oh, by the way, I don't expect more than 3 ties, but might in future when I attempt a tournament with 24 or 36 players.

Thanks again for the assistance.

Cheers,
Matcutter