Assigning points to teams based on place in conference standings

C

curtam

New Member
Joined
May 5, 2018
Messages
2
[TABLE="width: 500"]
<tbody>[TR]
[TD][TABLE="width: 1298"]
<tbody>[TR]
[TD="width: 64"][/TD]
[TD="class: xl81, width: 181, bgcolor: red, align: center"]RED[/TD]
[TD="class: xl88, width: 126, bgcolor: red, colspan: 2, align: center"]CONFERENCE[/TD]
[TD="class: xl88, width: 126, bgcolor: red, colspan: 2, align: center"]SEASON TOTAL[/TD]
[TD="width: 89"][/TD]
[TD="class: xl70, width: 89"][/TD]
[TD="class: xl92, width: 89, align: center"][/TD]
[TD="class: xl92, width: 89, align: center"][/TD]
[TD="class: xl92, width: 89, align: center"][/TD]
[TD="class: xl92, width: 89, align: center"][/TD]
[TD="class: xl92, width: 89, align: center"][/TD]
[TD="class: xl92, width: 89, align: center"][/TD]
[TD="class: xl92, width: 89, align: center"][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="class: xl74, bgcolor: red"][/TD]
[TD="class: xl85, bgcolor: red, align: center"]WIN[/TD]
[TD="class: xl86, bgcolor: red, align: center"]LOSS[/TD]
[TD="class: xl85, bgcolor: red, align: center"]WIN[/TD]
[TD="class: xl86, bgcolor: red, align: center"]LOSS[/TD]
[TD][/TD]
[TD][/TD]
[TD="class: xl94, align: center"]1[/TD]
[TD="class: xl94, align: center"]2[/TD]
[TD="class: xl94, align: center"]3[/TD]
[TD="class: xl94, align: center"]4[/TD]
[TD="class: xl94, align: center"]5[/TD]
[TD="class: xl94, align: center"]6[/TD]
[TD="class: xl94, align: center"]7[/TD]
[/TR]
[TR]
[TD="align: right"]1[/TD]
[TD="class: xl84, bgcolor: red"]Richards[/TD]
[TD="class: xl75, bgcolor: red, align: center"]2[/TD]
[TD="class: xl75, bgcolor: red, align: center"]0[/TD]
[TD="class: xl75, bgcolor: red, align: center"]2[/TD]
[TD="class: xl75, bgcolor: red, align: center"]0[/TD]
[TD][/TD]
[TD="class: xl93, align: right"]1[/TD]
[TD="class: xl92, align: center"]7[/TD]
[TD="class: xl92, align: center"]6[/TD]
[TD="class: xl92, align: center"]5[/TD]
[TD="class: xl92, align: center"]4[/TD]
[TD="class: xl92, align: center"]3[/TD]
[TD="class: xl92, align: center"]2[/TD]
[TD="class: xl92, align: center"]1[/TD]
[/TR]
[TR]
[TD="align: right"]2[/TD]
[TD="class: xl84, bgcolor: red"]Argo[/TD]
[TD="class: xl75, bgcolor: red, align: center"]1[/TD]
[TD="class: xl75, bgcolor: red, align: center"]0[/TD]
[TD="class: xl75, bgcolor: red, align: center"]2[/TD]
[TD="class: xl75, bgcolor: red, align: center"]0[/TD]
[TD][/TD]
[TD="class: xl93, align: right"]2[/TD]
[TD="class: xl92, align: center"]6.5[/TD]
[TD="class: xl92, align: center"]5.5[/TD]
[TD="class: xl92, align: center"]4.5[/TD]
[TD="class: xl92, align: center"]3.5[/TD]
[TD="class: xl92, align: center"]2.5[/TD]
[TD="class: xl92, align: center"]1.5[/TD]
[TD="class: xl92, align: center"][/TD]
[/TR]
[TR]
[TD="align: right"]2[/TD]
[TD="class: xl84, bgcolor: red"]Shepard[/TD]
[TD="class: xl75, bgcolor: red, align: center"]1[/TD]
[TD="class: xl75, bgcolor: red, align: center"]0[/TD]
[TD="class: xl75, bgcolor: red, align: center"]2[/TD]
[TD="class: xl75, bgcolor: red, align: center"]0[/TD]
[TD][/TD]
[TD="class: xl93, align: right"]3[/TD]
[TD="class: xl92, align: center"]6[/TD]
[TD="class: xl92, align: center"]5[/TD]
[TD="class: xl92, align: center"]4[/TD]
[TD="class: xl92, align: center"]3[/TD]
[TD="class: xl92, align: center"]2[/TD]
[TD="class: xl92, align: center"][/TD]
[TD="class: xl92, align: center"][/TD]
[/TR]
[TR]
[TD="align: right"]2[/TD]
[TD="class: xl84, bgcolor: red"]Evergreen Park[/TD]
[TD="class: xl75, bgcolor: red, align: center"]1[/TD]
[TD="class: xl75, bgcolor: red, align: center"]1[/TD]
[TD="class: xl75, bgcolor: red, align: center"]1[/TD]
[TD="class: xl75, bgcolor: red, align: center"]1[/TD]
[TD][/TD]
[TD="class: xl93, align: right"]4[/TD]
[TD="class: xl92, align: center"]5.5[/TD]
[TD="class: xl92, align: center"]4.5[/TD]
[TD="class: xl92, align: center"]3.5[/TD]
[TD="class: xl92, align: center"]2.5[/TD]
[TD="class: xl92, align: center"][/TD]
[TD="class: xl92, align: center"][/TD]
[TD="class: xl92, align: center"][/TD]
[/TR]
[TR]
[TD="align: right"]2[/TD]
[TD="class: xl84, bgcolor: red"]Reavis[/TD]
[TD="class: xl75, bgcolor: red, align: center"]1[/TD]
[TD="class: xl75, bgcolor: red, align: center"]1[/TD]
[TD="class: xl75, bgcolor: red, align: center"]1[/TD]
[TD="class: xl75, bgcolor: red, align: center"]1[/TD]
[TD][/TD]
[TD="class: xl93, align: right"]5[/TD]
[TD="class: xl92, align: center"]5[/TD]
[TD="class: xl92, align: center"]4[/TD]
[TD="class: xl92, align: center"]3[/TD]
[TD][/TD]
[TD][/TD]
[TD="class: xl92, align: center"][/TD]
[TD="class: xl92, align: center"][/TD]
[/TR]
[TR]
[TD="align: right"]6[/TD]
[TD="class: xl84, bgcolor: red"]Eisenhower[/TD]
[TD="class: xl75, bgcolor: red, align: center"]0[/TD]
[TD="class: xl75, bgcolor: red, align: center"]2[/TD]
[TD="class: xl75, bgcolor: red, align: center"]0[/TD]
[TD="class: xl75, bgcolor: red, align: center"]2[/TD]
[TD][/TD]
[TD="class: xl93, align: right"]6[/TD]
[TD="class: xl92, align: center"]4.5[/TD]
[TD="class: xl92, align: center"]3.5[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="class: xl92, align: center"][/TD]
[/TR]
[TR]
[TD="align: right"]6[/TD]
[TD="class: xl84, bgcolor: red"]Oak Lawn[/TD]
[TD="class: xl75, bgcolor: red, align: center"]0[/TD]
[TD="class: xl75, bgcolor: red, align: center"]2[/TD]
[TD="class: xl75, bgcolor: red, align: center"]0[/TD]
[TD="class: xl75, bgcolor: red, align: center"]2[/TD]
[TD][/TD]
[TD="class: xl93, align: right"]7[/TD]
[TD="class: xl92, align: center"]4[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="class: xl76"][/TD]
[TD="class: xl77, align: center"][/TD]
[TD="class: xl77, align: center"][/TD]
[TD="class: xl77, align: center"][/TD]
[TD="class: xl77, align: center"][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="class: xl76"][/TD]
[TD="class: xl76"][/TD]
[TD="class: xl76"][/TD]
[TD="class: xl76"][/TD]
[TD="class: xl76"][/TD]
[TD][/TD]
[TD][/TD]
[TD="class: xl94, align: center"]1[/TD]
[TD="class: xl94, align: center"]2[/TD]
[TD="class: xl94, align: center"]3[/TD]
[TD="class: xl94, align: center"]4[/TD]
[TD="class: xl94, align: center"]5[/TD]
[TD="class: xl94, align: center"]6[/TD]
[TD="class: xl94, align: center"]7[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="class: xl78, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=0070C0]#0070C0[/URL] , align: center"]BLUE[/TD]
[TD="class: xl90, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=0070C0]#0070C0[/URL] , colspan: 2, align: center"]CONFERENCE[/TD]
[TD="class: xl90, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=0070C0]#0070C0[/URL] , colspan: 2, align: center"]SEASON TOTAL[/TD]
[TD][/TD]
[TD="class: xl93, align: right"]1[/TD]
[TD="class: xl92, align: center"]7[/TD]
[TD="class: xl92, align: center"][/TD]
[TD="class: xl92, align: center"][/TD]
[TD="class: xl92, align: center"][/TD]
[TD="class: xl92, align: center"][/TD]
[TD="class: xl92, align: center"][/TD]
[TD="class: xl92, align: center"][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="class: xl79, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=0070C0]#0070C0[/URL] "][/TD]
[TD="class: xl82, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=0070C0]#0070C0[/URL] , align: center"]WIN[/TD]
[TD="class: xl83, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=0070C0]#0070C0[/URL] , align: center"]LOSS[/TD]
[TD="class: xl82, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=0070C0]#0070C0[/URL] , align: center"]WIN[/TD]
[TD="class: xl83, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=0070C0]#0070C0[/URL] , align: center"]LOSS[/TD]
[TD][/TD]
[TD="class: xl93, align: right"]2[/TD]
[TD="class: xl92, align: center"]13[/TD]
[TD="class: xl92, align: center"]6[/TD]
[TD="class: xl92, align: center"][/TD]
[TD="class: xl92, align: center"][/TD]
[TD="class: xl92, align: center"][/TD]
[TD="class: xl92, align: center"][/TD]
[TD="class: xl92, align: center"][/TD]
[/TR]
[TR]
[TD="align: right"]1[/TD]
[TD="class: xl87, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=0070C0]#0070C0[/URL] "]Lemont[/TD]
[TD="class: xl80, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=0070C0]#0070C0[/URL] , align: center"]1[/TD]
[TD="class: xl80, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=0070C0]#0070C0[/URL] , align: center"]0[/TD]
[TD="class: xl80, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=0070C0]#0070C0[/URL] , align: center"]1[/TD]
[TD="class: xl80, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=0070C0]#0070C0[/URL] , align: center"]0[/TD]
[TD][/TD]
[TD="class: xl93, align: right"]3[/TD]
[TD="class: xl92, align: center"]18[/TD]
[TD="class: xl92, align: center"]11[/TD]
[TD="class: xl92, align: center"]5[/TD]
[TD="class: xl92, align: center"][/TD]
[TD="class: xl92, align: center"][/TD]
[TD="class: xl92, align: center"][/TD]
[TD="class: xl92, align: center"][/TD]
[/TR]
[TR]
[TD="align: right"]1[/TD]
[TD="class: xl87, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=0070C0]#0070C0[/URL] "]Tinley Park[/TD]
[TD="class: xl80, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=0070C0]#0070C0[/URL] , align: center"]1[/TD]
[TD="class: xl80, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=0070C0]#0070C0[/URL] , align: center"]0[/TD]
[TD="class: xl80, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=0070C0]#0070C0[/URL] , align: center"]1[/TD]
[TD="class: xl80, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=0070C0]#0070C0[/URL] , align: center"]0[/TD]
[TD][/TD]
[TD="class: xl93, align: right"]4[/TD]
[TD="class: xl92, align: center"]22[/TD]
[TD="class: xl92, align: center"]15[/TD]
[TD="class: xl92, align: center"]9[/TD]
[TD="class: xl92, align: center"]4[/TD]
[TD="class: xl92, align: center"][/TD]
[TD="class: xl92, align: center"][/TD]
[TD="class: xl92, align: center"][/TD]
[/TR]
[TR]
[TD="align: right"]1[/TD]
[TD="class: xl87, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=0070C0]#0070C0[/URL] "]T.F. South[/TD]
[TD="class: xl80, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=0070C0]#0070C0[/URL] , align: center"]1[/TD]
[TD="class: xl80, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=0070C0]#0070C0[/URL] , align: center"]0[/TD]
[TD="class: xl80, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=0070C0]#0070C0[/URL] , align: center"]1[/TD]
[TD="class: xl80, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=0070C0]#0070C0[/URL] , align: center"]0[/TD]
[TD][/TD]
[TD="class: xl93, align: right"]5[/TD]
[TD="class: xl92, align: center"]25[/TD]
[TD="class: xl92, align: center"]18[/TD]
[TD="class: xl92, align: center"]12[/TD]
[TD="class: xl92, align: center"]7[/TD]
[TD="class: xl92, align: center"]3[/TD]
[TD="class: xl92, align: center"][/TD]
[TD="class: xl92, align: center"][/TD]
[/TR]
[TR]
[TD="align: right"]1[/TD]
[TD="class: xl87, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=0070C0]#0070C0[/URL] "]Hillcrest[/TD]
[TD="class: xl80, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=0070C0]#0070C0[/URL] , align: center"]1[/TD]
[TD="class: xl80, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=0070C0]#0070C0[/URL] , align: center"]0[/TD]
[TD="class: xl80, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=0070C0]#0070C0[/URL] , align: center"]1[/TD]
[TD="class: xl80, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=0070C0]#0070C0[/URL] , align: center"]1[/TD]
[TD][/TD]
[TD="class: xl93, align: right"]6[/TD]
[TD="class: xl92, align: center"]27[/TD]
[TD="class: xl92, align: center"]20[/TD]
[TD="class: xl92, align: center"]14[/TD]
[TD="class: xl92, align: center"]9[/TD]
[TD="class: xl92, align: center"]5[/TD]
[TD="class: xl92, align: center"]2[/TD]
[TD="class: xl92, align: center"][/TD]
[/TR]
[TR]
[TD="align: right"]5[/TD]
[TD="class: xl87, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=0070C0]#0070C0[/URL] "]Oak Forest[/TD]
[TD="class: xl80, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=0070C0]#0070C0[/URL] , align: center"]0[/TD]
[TD="class: xl80, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=0070C0]#0070C0[/URL] , align: center"]2[/TD]
[TD="class: xl80, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=0070C0]#0070C0[/URL] , align: center"]0[/TD]
[TD="class: xl80, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=0070C0]#0070C0[/URL] , align: center"]2[/TD]
[TD][/TD]
[TD="class: xl93, align: right"]7[/TD]
[TD="class: xl92, align: center"]28[/TD]
[TD="class: xl92, align: center"]21[/TD]
[TD="class: xl92, align: center"]15[/TD]
[TD="class: xl92, align: center"]10[/TD]
[TD="class: xl92, align: center"]6[/TD]
[TD="class: xl92, align: center"]3[/TD]
[TD="class: xl92, align: center"]1[/TD]
[/TR]
[TR]
[TD="align: right"]5[/TD]
[TD="class: xl87, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=0070C0]#0070C0[/URL] "]T.F. North[/TD]
[TD="class: xl80, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=0070C0]#0070C0[/URL] , align: center"]0[/TD]
[TD="class: xl80, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=0070C0]#0070C0[/URL] , align: center"]1[/TD]
[TD="class: xl80, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=0070C0]#0070C0[/URL] , align: center"]0[/TD]
[TD="class: xl80, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=0070C0]#0070C0[/URL] , align: center"]1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]5[/TD]
[TD="class: xl87, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=0070C0]#0070C0[/URL] "]Bremen[/TD]
[TD="class: xl80, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=0070C0]#0070C0[/URL] , align: center"]0[/TD]
[TD="class: xl80, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=0070C0]#0070C0[/URL] , align: center"]1[/TD]
[TD="class: xl80, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=0070C0]#0070C0[/URL] , align: center"]0[/TD]
[TD="class: xl80, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=0070C0]#0070C0[/URL] , align: center"]2[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]I am looking for a formula that will give me the correct number of points to each team based on their rank in the conference. Because of ties I need to figure that in as well. For example in the red table there is one team in first with four tied for second and two tied for sixth. The point breakdown is in the table to the right. "Richards" in my example would recieve 7 points as the only team currently in first place, while the four teams sharing second would each receive 4.5 points (adding 6, 5, 4, and 3 and dividing by 4). The two teams sharing sixth would then receive 1.5 points each as they slit the final three points available.
Is there a way to link through a formula the rank for each team to the data in the table to the right? Any solutions would be great as I am stuck on the proper way to right the formula. Thanks[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
 

Excel Facts

Excel motto
Not everything I do at work revolves around Excel. Only the fun parts.
Sort by date Sort by votes
Welcome to the forum.

Let me get this straight. Are you trying to break ties using conditions? Ignoring that table to the right, are you saying Richards is ranked 1 because it has 2 wins (as do Argo and Shepard) and also has 2 conference wins? Is that right?
 
Last edited:
Upvote 0
Thanks for the reply. I would actually like to have the teams placed by win percentage, then by head to head wins, then by total wins if possible. I just wasn't sure what the proper formula would be to try and do something like this
 
Upvote 0
Ranking things in a statistics table can be achieved by creating cascading rules by order of magnitude, creating a summary Grade for each team, and ranking according to that Grade. When you include the head-to-head data in the tie-breaking procedure, things become onerous and nearly impossible to do in Excel.

See these posts to get a feel for the issue, especially

https://www.mrexcel.com/forum/excel...t-highest-similar-values.html?highlight=grade

and also

https://www.mrexcel.com/forum/excel...tie-break-criteria.html?highlight=tie+breaker
https://www.mrexcel.com/forum/excel...sing-3-columns-data.html?highlight=rank+grade
 
Upvote 0
You must log in or register to reply here.

Similar threads

A
  • Solved
Conditional Formatting Dates including Dates Passed
Replies
7
Views
510
MARK858
MARK858
R
  • Question Question
VBA code that copies each option in a drop-down list and pastes it to a new workbook.
Replies
0
Views
237
Rephot
R
W
  • Question Question
Data lookup based upon date range
Replies
2
Views
107
bebo021999
B
B
  • Solved
Index Match to return an average
Replies
6
Views
342
Joe4
Joe4
E
  • Question Question
VBA code clean up
Replies
9
Views
478
mumps
mumps

Forum statistics

Threads
1,223,157
Messages
6,170,419
Members
452,325
Latest member
BlahQz

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top