And the winner is...

[tylertyler33]

Once the cells are filled for columns "1,2,3,4,5 and 6" I'd like a check mark (or any selected illustration) to automatically appear under the "Winner" column for the team with the most points. In the example below Team A defeats Team B 4.5-1.5. All cells are filled so can we get a check mark to appear. Thank you.


[TABLE="class: grid, width: 500, align: center"]
<tbody>[TR]
[TD][/TD]
[TD]1[/TD]
[TD]2[/TD]
[TD]3[/TD]
[TD]4[/TD]
[TD]5[/TD]
[TD]6[/TD]
[TD]Winner[/TD]
[/TR]
[TR]
[TD]Team A[/TD]
[TD]1[/TD]
[TD]0[/TD]
[TD]0.5[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Team B[/TD]
[TD]0[/TD]
[TD]1[/TD]
[TD]0.5[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[Scott T]

Excel 2010[TABLE="class: grid, width: 300"]
<colgroup><col><col><col><col><col><col><col><col><col></colgroup><tbody>[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[TD]F[/TD]
[TD]G[/TD]
[TD]H[/TD]
[/TR]
[TR]
[TD="align: center"]1[/TD]
[TD="align: right"][/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]6[/TD]
[TD]Winner[/TD]
[/TR]
[TR]
[TD="align: center"]2[/TD]
[TD]Team A[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0.5[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD]X[/TD]
[/TR]
[TR]
[TD="align: center"]3[/TD]
[TD]Team B[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0.5[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

Sheet6​

[TABLE="width: 85%"]
<tbody>[TR]
[TD]Worksheet Formulas[TABLE="class: grid, width: 100%"]
<tbody>[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]
[TD="width: 10"]Cell[/TD]
[TD="align: left"]Formula[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]H2[/TH]
[TD="align: left"]=IF(COUNT(B2:G3)=12,IF(SUM(B2:G2)>SUM(B3:G3),"X",""),"")[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]H3[/TH]
[TD="align: left"]=IF(COUNT(B2:G3)=12,IF(SUM(B2:G2)<SUM(B3:G3),"X",""),"")[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]

 

[tylertyler33]

It's possible Team B can be the winner as well. Currently, the formula doesn't support that. It works like a charm if Team A is the winner.

 

[Scott T]

The formula for H3 did not post right. remove the space around the <

=IF(COUNT(B2:G3)=12,IF(SUM(B2:G2) < SUM(B3:G3),"X",""),"")