Finding 1st, 2nd & 3rd place with ties

[confusedjo]

Would be grateful for any help:- Im needing to find all 1st, 2nd and 3rd places including any ties. I need to find all 1st, 2nd and 3rd places for each grade (there are 4 A,B,C,D) for each round (there are 6) Name col = D6:D152, Grade Col = E6:E152, Round 1 Total col = K6:k152
Round2 Total col = N6:N152, Round3 Total col = Q6:Q152, Round4 Total Col =T6:T152, Round5 col = W6:W152, Round6 col = Z6:z152
Results need to be Name, Grade with Score.

Table details:-
<TABLE style="WIDTH: 452pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=602><COLGROUP><COL style="WIDTH: 156pt; mso-width-source: userset; mso-width-alt: 6656" width=208><COL style="WIDTH: 44pt; mso-width-source: userset; mso-width-alt: 1856" width=58><COL style="WIDTH: 41pt; mso-width-source: userset; mso-width-alt: 1760" width=55><COL style="WIDTH: 41pt; mso-width-source: userset; mso-width-alt: 1760" width=55><COL style="WIDTH: 44pt; mso-width-source: userset; mso-width-alt: 1856" width=58><COL style="WIDTH: 41pt; mso-width-source: userset; mso-width-alt: 1760" width=55><COL style="WIDTH: 41pt; mso-width-source: userset; mso-width-alt: 1760" width=55><COL style="WIDTH: 44pt; mso-width-source: userset; mso-width-alt: 1856" width=58><TBODY><TR style="HEIGHT: 42pt; mso-height-source: userset" height=56><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 156pt; FONT-FAMILY: 'Arial Narrow'; BACKGROUND: #ccecff; HEIGHT: 42pt; COLOR: windowtext; FONT-SIZE: 10pt; BORDER-TOP: #f0f0f0; FONT-WEIGHT: 700; BORDER-RIGHT: #f0f0f0; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" class=xl87 height=56 width=208>NAME</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 44pt; FONT-FAMILY: 'Arial Narrow'; BACKGROUND: #ccecff; COLOR: windowtext; FONT-SIZE: 10pt; BORDER-TOP: #f0f0f0; FONT-WEIGHT: 700; BORDER-RIGHT: #f0f0f0; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" class=xl87 width=58>GRADE</TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: #f0f0f0; WIDTH: 41pt; FONT-FAMILY: 'Arial Narrow'; BACKGROUND: #ccecff; COLOR: windowtext; FONT-SIZE: 10pt; BORDER-TOP: #f0f0f0; FONT-WEIGHT: 700; BORDER-RIGHT: #f0f0f0; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" class=xl100 width=55>SCORE 25</TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: #f0f0f0; WIDTH: 41pt; FONT-FAMILY: 'Arial Narrow'; BACKGROUND: #ccecff; COLOR: windowtext; FONT-SIZE: 10pt; BORDER-TOP: #f0f0f0; FONT-WEIGHT: 700; BORDER-RIGHT: windowtext 1pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" class=xl93 width=55>SCORE 25</TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: #f0f0f0; WIDTH: 44pt; FONT-FAMILY: 'Arial Narrow'; BACKGROUND: #ccecff; COLOR: black; FONT-SIZE: 10pt; BORDER-TOP: #f0f0f0; FONT-WEIGHT: 700; BORDER-RIGHT: #f0f0f0; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" class=xl94 width=58>Total </TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext 1pt solid; WIDTH: 41pt; FONT-FAMILY: 'Arial Narrow'; BACKGROUND: #ccecff; COLOR: black; FONT-SIZE: 10pt; BORDER-TOP: #f0f0f0; FONT-WEIGHT: 700; BORDER-RIGHT: #f0f0f0; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" class=xl95 width=55>SCORE 25</TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: #f0f0f0; WIDTH: 41pt; FONT-FAMILY: 'Arial Narrow'; BACKGROUND: #ccecff; COLOR: black; FONT-SIZE: 10pt; BORDER-TOP: #f0f0f0; FONT-WEIGHT: 700; BORDER-RIGHT: windowtext 1pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" class=xl96 width=55>SCORE 25</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 44pt; FONT-FAMILY: 'Arial Narrow'; BACKGROUND: #ccecff; COLOR: black; FONT-SIZE: 10pt; BORDER-TOP: #f0f0f0; FONT-WEIGHT: 700; BORDER-RIGHT: #f0f0f0; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" class=xl89 width=58>Total </TD></TR><TR style="HEIGHT: 16.5pt; mso-height-source: userset" height=22><TD style="BORDER-BOTTOM: #bfbfbf 0.5pt solid; BORDER-LEFT: #bfbfbf 0.5pt solid; FONT-FAMILY: 'Arial Narrow'; BACKGROUND: white; HEIGHT: 16.5pt; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: windowtext 1pt solid; FONT-WEIGHT: 400; BORDER-RIGHT: #bfbfbf 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" class=xl73 height=22>Ben</TD><TD style="BORDER-BOTTOM: #bfbfbf 0.5pt solid; BORDER-LEFT: #bfbfbf 0.5pt solid; FONT-FAMILY: 'Arial Narrow'; BACKGROUND: white; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: windowtext 1pt solid; FONT-WEIGHT: 400; BORDER-RIGHT: #bfbfbf 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" class=xl74>B</TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: #f0f0f0; WIDTH: 41pt; FONT-FAMILY: 'Arial Narrow'; BACKGROUND: white; COLOR: windowtext; FONT-SIZE: 9pt; BORDER-TOP: #f0f0f0; FONT-WEIGHT: 400; BORDER-RIGHT: gray 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" class=xl101 width=55>10</TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: gray 0.5pt solid; WIDTH: 41pt; FONT-FAMILY: 'Arial Narrow'; BACKGROUND: white; COLOR: windowtext; FONT-SIZE: 9pt; BORDER-TOP: #f0f0f0; FONT-WEIGHT: 400; BORDER-RIGHT: windowtext 1pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" class=xl90 width=55>11</TD><TD style="BORDER-BOTTOM: #bfbfbf 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #d9d9d9; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1pt solid" class=xl83>21</TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: #f0f0f0; FONT-FAMILY: 'Arial Narrow'; BACKGROUND: white; COLOR: windowtext; FONT-SIZE: 9pt; BORDER-TOP: #f0f0f0; FONT-WEIGHT: 400; BORDER-RIGHT: gray 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" class=xl91>16</TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: gray 0.5pt solid; FONT-FAMILY: 'Arial Narrow'; BACKGROUND: white; COLOR: windowtext; FONT-SIZE: 9pt; BORDER-TOP: #f0f0f0; FONT-WEIGHT: 400; BORDER-RIGHT: #f0f0f0; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" class=xl92>18</TD><TD style="BORDER-BOTTOM: #bfbfbf 0.5pt solid; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #d9d9d9; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: windowtext 1pt solid" class=xl83>34</TD></TR><TR style="HEIGHT: 16.5pt; mso-height-source: userset" height=22><TD style="BORDER-BOTTOM: #bfbfbf 0.5pt solid; BORDER-LEFT: #bfbfbf 0.5pt solid; FONT-FAMILY: 'Arial Narrow'; BACKGROUND: white; HEIGHT: 16.5pt; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #bfbfbf 0.5pt solid; FONT-WEIGHT: 400; BORDER-RIGHT: #bfbfbf 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" class=xl65 height=22>Fred</TD><TD style="BORDER-BOTTOM: #bfbfbf 0.5pt solid; BORDER-LEFT: #bfbfbf 0.5pt solid; FONT-FAMILY: 'Arial Narrow'; BACKGROUND: white; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #f0f0f0; FONT-WEIGHT: 400; BORDER-RIGHT: #bfbfbf 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" class=xl69>A</TD><TD style="BORDER-BOTTOM: #bfbfbf 0.5pt solid; BORDER-LEFT: #f0f0f0; FONT-FAMILY: 'Arial Narrow'; BACKGROUND: white; COLOR: windowtext; FONT-SIZE: 11pt; BORDER-TOP: #bfbfbf 0.5pt solid; FONT-WEIGHT: 400; BORDER-RIGHT: #bfbfbf 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" class=xl84>21</TD><TD style="BORDER-BOTTOM: #bfbfbf 0.5pt solid; BORDER-LEFT: #bfbfbf 0.5pt solid; FONT-FAMILY: 'Arial Narrow'; BACKGROUND: white; COLOR: windowtext; FONT-SIZE: 11pt; BORDER-TOP: #bfbfbf 0.5pt solid; FONT-WEIGHT: 400; BORDER-RIGHT: windowtext 1pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" class=xl77>21</TD><TD style="BORDER-BOTTOM: #bfbfbf 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #d9d9d9; BORDER-TOP: #bfbfbf; BORDER-RIGHT: #f0f0f0" class=xl81>42</TD><TD style="BORDER-BOTTOM: #bfbfbf 0.5pt solid; BORDER-LEFT: windowtext 1pt solid; FONT-FAMILY: 'Arial Narrow'; BACKGROUND: white; COLOR: windowtext; FONT-SIZE: 11pt; BORDER-TOP: #bfbfbf 0.5pt solid; FONT-WEIGHT: 400; BORDER-RIGHT: #bfbfbf 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" class=xl71>25</TD><TD style="BORDER-BOTTOM: #bfbfbf 0.5pt solid; BORDER-LEFT: #bfbfbf 0.5pt solid; FONT-FAMILY: 'Arial Narrow'; BACKGROUND: white; COLOR: windowtext; FONT-SIZE: 11pt; BORDER-TOP: #bfbfbf 0.5pt solid; FONT-WEIGHT: 400; BORDER-RIGHT: windowtext 1pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" class=xl77>25</TD><TD style="BORDER-BOTTOM: #bfbfbf 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #d9d9d9; BORDER-TOP: #bfbfbf; BORDER-RIGHT: #f0f0f0" class=xl81>50</TD></TR><TR style="HEIGHT: 16.5pt; mso-height-source: userset" height=22><TD style="BORDER-BOTTOM: #bfbfbf 0.5pt solid; BORDER-LEFT: #bfbfbf 0.5pt solid; FONT-FAMILY: 'Arial Narrow'; BACKGROUND: white; HEIGHT: 16.5pt; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #bfbfbf 0.5pt solid; FONT-WEIGHT: 400; BORDER-RIGHT: #bfbfbf 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" class=xl65 height=22>Sarah </TD><TD style="BORDER-BOTTOM: #bfbfbf 0.5pt solid; BORDER-LEFT: #bfbfbf 0.5pt solid; FONT-FAMILY: 'Arial Narrow'; BACKGROUND: white; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #f0f0f0; FONT-WEIGHT: 400; BORDER-RIGHT: #bfbfbf 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" class=xl69>A</TD><TD style="BORDER-BOTTOM: #bfbfbf 0.5pt solid; BORDER-LEFT: #f0f0f0; FONT-FAMILY: 'Arial Narrow'; BACKGROUND: white; COLOR: windowtext; FONT-SIZE: 11pt; BORDER-TOP: #bfbfbf 0.5pt solid; FONT-WEIGHT: 400; BORDER-RIGHT: #bfbfbf 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" class=xl84>23</TD><TD style="BORDER-BOTTOM: #bfbfbf 0.5pt solid; BORDER-LEFT: #bfbfbf 0.5pt solid; FONT-FAMILY: 'Arial Narrow'; BACKGROUND: white; COLOR: windowtext; FONT-SIZE: 11pt; BORDER-TOP: #bfbfbf 0.5pt solid; FONT-WEIGHT: 400; BORDER-RIGHT: windowtext 1pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" class=xl77>23</TD><TD style="BORDER-BOTTOM: #bfbfbf 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #d9d9d9; BORDER-TOP: #bfbfbf; BORDER-RIGHT: #f0f0f0" class=xl81>46</TD><TD style="BORDER-BOTTOM: #bfbfbf 0.5pt solid; BORDER-LEFT: windowtext 1pt solid; FONT-FAMILY: 'Arial Narrow'; BACKGROUND: white; COLOR: windowtext; FONT-SIZE: 11pt; BORDER-TOP: #bfbfbf 0.5pt solid; FONT-WEIGHT: 400; BORDER-RIGHT: #bfbfbf 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" class=xl71>22</TD><TD style="BORDER-BOTTOM: #bfbfbf 0.5pt solid; BORDER-LEFT: #bfbfbf 0.5pt solid; FONT-FAMILY: 'Arial Narrow'; BACKGROUND: white; COLOR: windowtext; FONT-SIZE: 11pt; BORDER-TOP: #bfbfbf 0.5pt solid; FONT-WEIGHT: 400; BORDER-RIGHT: windowtext 1pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" class=xl77>22</TD><TD style="BORDER-BOTTOM: #bfbfbf 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #d9d9d9; BORDER-TOP: #bfbfbf; BORDER-RIGHT: #f0f0f0" class=xl81>44</TD></TR><TR style="HEIGHT: 16.5pt; mso-height-source: userset" height=22><TD style="BORDER-BOTTOM: #bfbfbf 0.5pt solid; BORDER-LEFT: #bfbfbf 0.5pt solid; FONT-FAMILY: 'Arial Narrow'; BACKGROUND: white; HEIGHT: 16.5pt; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #bfbfbf 0.5pt solid; FONT-WEIGHT: 400; BORDER-RIGHT: #bfbfbf 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" class=xl65 height=22>Tom</TD><TD style="BORDER-BOTTOM: #bfbfbf 0.5pt solid; BORDER-LEFT: #bfbfbf 0.5pt solid; FONT-FAMILY: 'Arial Narrow'; BACKGROUND: white; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #f0f0f0; FONT-WEIGHT: 400; BORDER-RIGHT: #bfbfbf 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" class=xl69>A</TD><TD style="BORDER-BOTTOM: #bfbfbf 0.5pt solid; BORDER-LEFT: #f0f0f0; FONT-FAMILY: 'Arial Narrow'; BACKGROUND: white; COLOR: windowtext; FONT-SIZE: 11pt; BORDER-TOP: #bfbfbf 0.5pt solid; FONT-WEIGHT: 400; BORDER-RIGHT: #bfbfbf 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" class=xl84>21</TD><TD style="BORDER-BOTTOM: #bfbfbf 0.5pt solid; BORDER-LEFT: #bfbfbf 0.5pt solid; FONT-FAMILY: 'Arial Narrow'; BACKGROUND: white; COLOR: windowtext; FONT-SIZE: 11pt; BORDER-TOP: #bfbfbf 0.5pt solid; FONT-WEIGHT: 400; BORDER-RIGHT: windowtext 1pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" class=xl77>23</TD><TD style="BORDER-BOTTOM: #bfbfbf 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #d9d9d9; BORDER-TOP: #bfbfbf; BORDER-RIGHT: #f0f0f0" class=xl81>44</TD><TD style="BORDER-BOTTOM: #bfbfbf 0.5pt solid; BORDER-LEFT: windowtext 1pt solid; FONT-FAMILY: 'Arial Narrow'; BACKGROUND: white; COLOR: windowtext; FONT-SIZE: 11pt; BORDER-TOP: #bfbfbf 0.5pt solid; FONT-WEIGHT: 400; BORDER-RIGHT: #bfbfbf 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" class=xl71>21</TD><TD style="BORDER-BOTTOM: #bfbfbf 0.5pt solid; BORDER-LEFT: #bfbfbf 0.5pt solid; FONT-FAMILY: 'Arial Narrow'; BACKGROUND: white; COLOR: windowtext; FONT-SIZE: 11pt; BORDER-TOP: #bfbfbf 0.5pt solid; FONT-WEIGHT: 400; BORDER-RIGHT: windowtext 1pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" class=xl77>23</TD><TD style="BORDER-BOTTOM: #bfbfbf 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #d9d9d9; BORDER-TOP: #bfbfbf; BORDER-RIGHT: #f0f0f0" class=xl81>44</TD></TR><TR style="HEIGHT: 17.25pt; mso-height-source: userset" height=23><TD style="BORDER-BOTTOM: #bfbfbf 0.5pt solid; BORDER-LEFT: #bfbfbf 0.5pt solid; FONT-FAMILY: 'Arial Narrow'; BACKGROUND: white; HEIGHT: 17.25pt; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #bfbfbf 0.5pt solid; FONT-WEIGHT: 400; BORDER-RIGHT: #bfbfbf 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" class=xl65 height=23>henry</TD><TD style="BORDER-BOTTOM: #bfbfbf 0.5pt solid; BORDER-LEFT: #bfbfbf 0.5pt solid; FONT-FAMILY: 'Arial Narrow'; BACKGROUND: white; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #bfbfbf 0.5pt solid; FONT-WEIGHT: 400; BORDER-RIGHT: #bfbfbf 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" class=xl66>B</TD><TD style="BORDER-BOTTOM: #bfbfbf 0.5pt solid; BORDER-LEFT: #f0f0f0; FONT-FAMILY: 'Arial Narrow'; BACKGROUND: white; COLOR: windowtext; FONT-SIZE: 11pt; BORDER-TOP: #bfbfbf 0.5pt solid; FONT-WEIGHT: 400; BORDER-RIGHT: #bfbfbf 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" class=xl84>10</TD><TD style="BORDER-BOTTOM: #bfbfbf 0.5pt solid; BORDER-LEFT: #bfbfbf 0.5pt solid; FONT-FAMILY: 'Arial Narrow'; BACKGROUND: white; COLOR: windowtext; FONT-SIZE: 11pt; BORDER-TOP: #bfbfbf 0.5pt solid; FONT-WEIGHT: 400; BORDER-RIGHT: windowtext 1pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" class=xl77>11</TD><TD style="BORDER-BOTTOM: #bfbfbf 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #d9d9d9; BORDER-TOP: #bfbfbf; BORDER-RIGHT: #f0f0f0" class=xl81>21</TD><TD style="BORDER-BOTTOM: #bfbfbf 0.5pt solid; BORDER-LEFT: windowtext 1pt solid; FONT-FAMILY: 'Arial Narrow'; BACKGROUND: white; COLOR: windowtext; FONT-SIZE: 11pt; BORDER-TOP: #bfbfbf 0.5pt solid; FONT-WEIGHT: 400; BORDER-RIGHT: #bfbfbf 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" class=xl71>10</TD><TD style="BORDER-BOTTOM: #bfbfbf 0.5pt solid; BORDER-LEFT: #bfbfbf 0.5pt solid; FONT-FAMILY: 'Arial Narrow'; BACKGROUND: white; COLOR: windowtext; FONT-SIZE: 11pt; BORDER-TOP: #bfbfbf 0.5pt solid; FONT-WEIGHT: 400; BORDER-RIGHT: windowtext 1pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" class=xl77>11</TD><TD style="BORDER-BOTTOM: #bfbfbf 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #d9d9d9; BORDER-TOP: #bfbfbf; BORDER-RIGHT: #f0f0f0" class=xl81>21</TD></TR><TR style="HEIGHT: 18.75pt; mso-height-source: userset" height=25><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: #bfbfbf 0.5pt solid; FONT-FAMILY: 'Arial Narrow'; BACKGROUND: white; HEIGHT: 18.75pt; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #bfbfbf 0.5pt solid; FONT-WEIGHT: 400; BORDER-RIGHT: #bfbfbf 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" class=xl75 height=25>emma</TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: #bfbfbf 0.5pt solid; FONT-FAMILY: 'Arial Narrow'; BACKGROUND: white; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #bfbfbf 0.5pt solid; FONT-WEIGHT: 400; BORDER-RIGHT: #bfbfbf 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" class=xl76>B</TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: #f0f0f0; FONT-FAMILY: 'Arial Narrow'; BACKGROUND: white; COLOR: windowtext; FONT-SIZE: 11pt; BORDER-TOP: #bfbfbf 0.5pt solid; FONT-WEIGHT: 400; BORDER-RIGHT: #bfbfbf 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" class=xl85>22</TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: #bfbfbf 0.5pt solid; FONT-FAMILY: 'Arial Narrow'; BACKGROUND: white; COLOR: windowtext; FONT-SIZE: 11pt; BORDER-TOP: #bfbfbf 0.5pt solid; FONT-WEIGHT: 400; BORDER-RIGHT: windowtext 1pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" class=xl78>21</TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #d9d9d9; BORDER-TOP: #bfbfbf; BORDER-RIGHT: #f0f0f0" class=xl82>43</TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext 1pt solid; FONT-FAMILY: 'Arial Narrow'; BACKGROUND: white; COLOR: windowtext; FONT-SIZE: 11pt; BORDER-TOP: #bfbfbf 0.5pt solid; FONT-WEIGHT: 400; BORDER-RIGHT: #bfbfbf 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" class=xl72>15</TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: #bfbfbf 0.5pt solid; FONT-FAMILY: 'Arial Narrow'; BACKGROUND: white; COLOR: windowtext; FONT-SIZE: 11pt; BORDER-TOP: #bfbfbf 0.5pt solid; FONT-WEIGHT: 400; BORDER-RIGHT: windowtext 1pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" class=xl78>16</TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #d9d9d9; BORDER-TOP: #bfbfbf; BORDER-RIGHT: #f0f0f0" class=xl82>31</TD></TR></TBODY></TABLE>

 

[Robert Mika]

What's a disered results from this table should be?

 

[confusedjo]

I would like to have the name grade and score of first second and third places of each grade including ties

 

[Robert Mika]

So in situation from the for Grade A the result would be:

Sarah 46
Tom 44
Fred 42

?

 

[saturdaygig]

I think the result he wants would be

Fred 50 - 1st
Sarah 44 - 2nd=
Tom 44 - 2nd=

 

[confusedjo]

Sorry I didnt understand your questions

Results:-
A Grade Round 1
1st = Sarah 46
2nd = Tom 44
3rd = Fred 42


B Grade Round 1
1st = Emma 43
2nd = Ben 21
= Henry 21

 

[Robert Mika]

<TABLE style="WIDTH: 522pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=695><COLGROUP><COL style="WIDTH: 48pt" span=6 width=64><COL style="WIDTH: 36pt; mso-width-source: userset; mso-width-alt: 1755" width=48><COL style="WIDTH: 71pt; mso-width-source: userset; mso-width-alt: 3437" width=94><COL style="WIDTH: 46pt; mso-width-source: userset; mso-width-alt: 2230" width=61><COL style="WIDTH: 35pt; mso-width-source: userset; mso-width-alt: 1718" width=47><COL style="WIDTH: 46pt; mso-width-source: userset; mso-width-alt: 2230" width=61><TBODY><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; WIDTH: 48pt; HEIGHT: 12.75pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 height=17 width=64>NAME</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 width=64>GRADE</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 width=64>SCORE 25</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 width=64>SCORE 25</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 width=64>Total </TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 width=64>SCORE 25</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 36pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 width=48>SCORE 25</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 71pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 width=94>Total</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #eeece1; WIDTH: 46pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66 width=61> </TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #eeece1; WIDTH: 35pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66 width=47> </TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #eeece1; WIDTH: 46pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66 width=61> </TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 12.75pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 height=17>Ben</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65>B</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 align=right>10</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 align=right>11</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 align=right>21</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 align=right>16</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 align=right>18</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 align=right>34</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #eeece1; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66>a</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #eeece1; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66 align=right>46</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #eeece1; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66>Sarah </TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 12.75pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 height=17>Fred</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65>A</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 align=right>21</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 align=right>21</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 align=right>42</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 align=right>25</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 align=right>25</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 align=right>50</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #eeece1; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66>a</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #eeece1; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66 align=right>44</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #eeece1; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66>Tom</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 12.75pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 height=17>Sarah </TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65>A</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 align=right>23</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 align=right>23</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 align=right>46</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 align=right>22</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 align=right>22</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 align=right>44</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #eeece1; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66>a</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #eeece1; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66 align=right>42</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #eeece1; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66>Fred</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 12.75pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 height=17>Tom</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65>A</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 align=right>21</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 align=right>23</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 align=right>44</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 align=right>21</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 align=right>23</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 align=right>44</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #eeece1; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66>b</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #eeece1; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66 align=right>43</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #eeece1; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66>emma</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 12.75pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 height=17>henry</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65>B</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 align=right>10</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 align=right>11</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 align=right>21</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 align=right>10</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 align=right>11</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 align=right>21</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #eeece1; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66>b</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #eeece1; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66 align=right>21</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #eeece1; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66>Ben</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 12.75pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 height=17>emma</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65>B</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 align=right>22</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 align=right>21</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 align=right>43</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 align=right>15</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 align=right>16</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 align=right>31</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #eeece1; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66>b</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #eeece1; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66 align=right>21</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #eeece1; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66>henry</TD></TR></TBODY></TABLE>

That's your data D to K.
In L put a and b as many times as you required then in M1:

=LARGE(IF($E$2:$E$7=L2,H$2:H$7),ROW(F1))
copy to M3


then from M4 to M6

=LARGE(IF($E$2:$E$7=L5,H$2:H$7),ROW(F1))

then from N2 copy down


=INDEX($D$2:$D$7,SMALL(IF($H$2:$H$7=M2,IF($E$2:$E$7=L2,ROW($E$2:$E$7)-ROW($E$1))),COUNTIF($M$2:M2,$M2)))

All array formulas -confirm CTRL+SHIFT+ENTER

 

[confusedjo]

Sweet!
Thank you so much.

 

[confusedjo]

I am having a few problems with this formula - I am getting incorrect returns :-
Current table

Col A Col B Col D Col E Col F Col G
<TABLE style="WIDTH: 231pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=308><COLGROUP><COL style="WIDTH: 37pt; mso-width-source: userset; mso-width-alt: 1568" width=49><COL style="WIDTH: 51pt; mso-width-source: userset; mso-width-alt: 2176" width=68><COL style="WIDTH: 42pt; mso-width-source: userset; mso-width-alt: 1792" width=56><COL style="WIDTH: 33pt; mso-width-source: userset; mso-width-alt: 1408" width=44><COL style="WIDTH: 32pt; mso-width-source: userset; mso-width-alt: 1376" width=43><COL style="WIDTH: 36pt; mso-width-source: userset; mso-width-alt: 1536" width=48><TBODY><TR style="HEIGHT: 39pt; mso-height-source: userset" height=52><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #f2f2f2; WIDTH: 37pt; HEIGHT: 39pt; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: #f0f0f0" class=xl70 height=52 width=49>Shooter No</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: gray 0.5pt solid; BACKGROUND-COLOR: #f2f2f2; WIDTH: 51pt; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: #f0f0f0" class=xl71 width=68>NAME</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: gray 0.5pt solid; BACKGROUND-COLOR: #f2f2f2; WIDTH: 42pt; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: #f0f0f0" class=xl72 width=56>GRADE</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #f2f2f2; WIDTH: 33pt; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: #f0f0f0" class=xl73 width=44>SPEC GRADE</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #f2f2f2; WIDTH: 32pt; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: #f0f0f0" class=xl70 width=43>SCORE 50</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #d9d9d9 0.5pt solid; BACKGROUND-COLOR: #f2f2f2; WIDTH: 36pt; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: #f0f0f0" class=xl74 width=48>SCORE 502</TD></TR><TR style="HEIGHT: 16.5pt; mso-height-source: userset" height=22><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: white; WIDTH: 37pt; HEIGHT: 16.5pt; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: #f0f0f0" class=xl75 height=22 width=49>1</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #d9d9d9 0.5pt solid; BACKGROUND-COLOR: white; WIDTH: 51pt; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: #f0f0f0" class=xl77 width=68>fred</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #d9d9d9 0.5pt solid; BACKGROUND-COLOR: white; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: #f0f0f0" class=xl78>a</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #d9d9d9 0.5pt solid; BACKGROUND-COLOR: white; WIDTH: 33pt; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: #f0f0f0" class=xl79 width=44>l</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: white; WIDTH: 32pt; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: #f0f0f0" class=xl75 width=43>25</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #d9d9d9 0.5pt solid; BACKGROUND-COLOR: white; WIDTH: 36pt; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: #f0f0f0" class=xl79 width=48>32</TD></TR><TR style="HEIGHT: 16.5pt; mso-height-source: userset" height=22><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: white; WIDTH: 37pt; HEIGHT: 16.5pt; BORDER-TOP: #d9d9d9 0.5pt solid; BORDER-RIGHT: #f0f0f0" class=xl80 height=22 width=49>2</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #d9d9d9 0.5pt solid; BACKGROUND-COLOR: white; WIDTH: 51pt; BORDER-TOP: #d9d9d9 0.5pt solid; BORDER-RIGHT: #f0f0f0" class=xl82 width=68>joshua</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #d9d9d9 0.5pt solid; BACKGROUND-COLOR: white; BORDER-TOP: #d9d9d9 0.5pt solid; BORDER-RIGHT: #f0f0f0" class=xl83>a</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #d9d9d9 0.5pt solid; BACKGROUND-COLOR: white; WIDTH: 33pt; BORDER-TOP: #d9d9d9 0.5pt solid; BORDER-RIGHT: #f0f0f0" class=xl84 width=44> </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: white; WIDTH: 32pt; BORDER-TOP: #d9d9d9 0.5pt solid; BORDER-RIGHT: #f0f0f0" class=xl80 width=43>30</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #d9d9d9 0.5pt solid; BACKGROUND-COLOR: white; WIDTH: 36pt; BORDER-TOP: #d9d9d9 0.5pt solid; BORDER-RIGHT: #f0f0f0" class=xl84 width=48>30</TD></TR><TR style="HEIGHT: 16.5pt; mso-height-source: userset" height=22><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: white; WIDTH: 37pt; HEIGHT: 16.5pt; BORDER-TOP: #d9d9d9 0.5pt solid; BORDER-RIGHT: #f0f0f0" class=xl80 height=22 width=49>3</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #d9d9d9 0.5pt solid; BACKGROUND-COLOR: white; WIDTH: 51pt; BORDER-TOP: #d9d9d9 0.5pt solid; BORDER-RIGHT: #f0f0f0" class=xl82 width=68>ben</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #d9d9d9 0.5pt solid; BACKGROUND-COLOR: white; BORDER-TOP: #d9d9d9 0.5pt solid; BORDER-RIGHT: #f0f0f0" class=xl83>a</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #d9d9d9 0.5pt solid; BACKGROUND-COLOR: white; WIDTH: 33pt; BORDER-TOP: #d9d9d9 0.5pt solid; BORDER-RIGHT: #f0f0f0" class=xl84 width=44> </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: white; WIDTH: 32pt; BORDER-TOP: #d9d9d9 0.5pt solid; BORDER-RIGHT: #f0f0f0" class=xl80 width=43>31</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #d9d9d9 0.5pt solid; BACKGROUND-COLOR: white; WIDTH: 36pt; BORDER-TOP: #d9d9d9 0.5pt solid; BORDER-RIGHT: #f0f0f0" class=xl84 width=48>30</TD></TR><TR style="HEIGHT: 16.5pt; mso-height-source: userset" height=22><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: white; WIDTH: 37pt; HEIGHT: 16.5pt; BORDER-TOP: #d9d9d9 0.5pt solid; BORDER-RIGHT: #f0f0f0" class=xl80 height=22 width=49>4</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #d9d9d9 0.5pt solid; BACKGROUND-COLOR: white; WIDTH: 51pt; BORDER-TOP: #d9d9d9 0.5pt solid; BORDER-RIGHT: #f0f0f0" class=xl82 width=68>henry</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #d9d9d9 0.5pt solid; BACKGROUND-COLOR: white; BORDER-TOP: #d9d9d9 0.5pt solid; BORDER-RIGHT: #f0f0f0" class=xl83>c</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #d9d9d9 0.5pt solid; BACKGROUND-COLOR: white; WIDTH: 33pt; BORDER-TOP: #d9d9d9 0.5pt solid; BORDER-RIGHT: #f0f0f0" class=xl84 width=44> </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: white; WIDTH: 32pt; BORDER-TOP: #d9d9d9 0.5pt solid; BORDER-RIGHT: #f0f0f0" class=xl80 width=43>30</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #d9d9d9 0.5pt solid; BACKGROUND-COLOR: white; WIDTH: 36pt; BORDER-TOP: #d9d9d9 0.5pt solid; BORDER-RIGHT: #f0f0f0" class=xl84 width=48>24</TD></TR><TR style="HEIGHT: 16.5pt; mso-height-source: userset" height=22><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: white; WIDTH: 37pt; HEIGHT: 16.5pt; BORDER-TOP: #d9d9d9 0.5pt solid; BORDER-RIGHT: #f0f0f0" class=xl80 height=22 width=49>5</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #d9d9d9 0.5pt solid; BACKGROUND-COLOR: white; WIDTH: 51pt; BORDER-TOP: #d9d9d9 0.5pt solid; BORDER-RIGHT: #f0f0f0" class=xl82 width=68>ben</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #d9d9d9 0.5pt solid; BACKGROUND-COLOR: white; BORDER-TOP: #d9d9d9 0.5pt solid; BORDER-RIGHT: #f0f0f0" class=xl83>a</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #d9d9d9 0.5pt solid; BACKGROUND-COLOR: white; WIDTH: 33pt; BORDER-TOP: #d9d9d9 0.5pt solid; BORDER-RIGHT: #f0f0f0" class=xl84 width=44> </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: white; WIDTH: 32pt; BORDER-TOP: #d9d9d9 0.5pt solid; BORDER-RIGHT: #f0f0f0" class=xl80 width=43>25</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #d9d9d9 0.5pt solid; BACKGROUND-COLOR: white; WIDTH: 36pt; BORDER-TOP: #d9d9d9 0.5pt solid; BORDER-RIGHT: #f0f0f0" class=xl84 width=48> </TD></TR><TR style="HEIGHT: 16.5pt; mso-height-source: userset" height=22><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: white; WIDTH: 37pt; HEIGHT: 16.5pt; BORDER-TOP: #d9d9d9 0.5pt solid; BORDER-RIGHT: #f0f0f0" class=xl80 height=22 width=49>6</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #d9d9d9 0.5pt solid; BACKGROUND-COLOR: white; WIDTH: 51pt; BORDER-TOP: #d9d9d9 0.5pt solid; BORDER-RIGHT: #f0f0f0" class=xl82 width=68>sarah</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #d9d9d9 0.5pt solid; BACKGROUND-COLOR: white; BORDER-TOP: #d9d9d9 0.5pt solid; BORDER-RIGHT: #f0f0f0" class=xl83>a</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #d9d9d9 0.5pt solid; BACKGROUND-COLOR: white; WIDTH: 33pt; BORDER-TOP: #d9d9d9 0.5pt solid; BORDER-RIGHT: #f0f0f0" class=xl84 width=44> </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: white; WIDTH: 32pt; BORDER-TOP: #d9d9d9 0.5pt solid; BORDER-RIGHT: #f0f0f0" class=xl80 width=43>31</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #d9d9d9 0.5pt solid; BACKGROUND-COLOR: white; WIDTH: 36pt; BORDER-TOP: #d9d9d9 0.5pt solid; BORDER-RIGHT: #f0f0f0" class=xl84 width=48> </TD></TR><TR style="HEIGHT: 16.5pt; mso-height-source: userset" height=22><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: white; WIDTH: 37pt; HEIGHT: 16.5pt; BORDER-TOP: #d9d9d9 0.5pt solid; BORDER-RIGHT: #f0f0f0" class=xl80 height=22 width=49>7</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #d9d9d9 0.5pt solid; BACKGROUND-COLOR: white; WIDTH: 51pt; BORDER-TOP: #d9d9d9 0.5pt solid; BORDER-RIGHT: #f0f0f0" class=xl82 width=68>bob</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #d9d9d9 0.5pt solid; BACKGROUND-COLOR: white; BORDER-TOP: #d9d9d9 0.5pt solid; BORDER-RIGHT: #f0f0f0" class=xl83>b</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #d9d9d9 0.5pt solid; BACKGROUND-COLOR: white; WIDTH: 33pt; BORDER-TOP: #d9d9d9 0.5pt solid; BORDER-RIGHT: #f0f0f0" class=xl84 width=44> </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: white; WIDTH: 32pt; BORDER-TOP: #d9d9d9 0.5pt solid; BORDER-RIGHT: #f0f0f0" class=xl80 width=43> </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #d9d9d9 0.5pt solid; BACKGROUND-COLOR: white; WIDTH: 36pt; BORDER-TOP: #d9d9d9 0.5pt solid; BORDER-RIGHT: #f0f0f0" class=xl84 width=48> </TD></TR><TR style="HEIGHT: 16.5pt; mso-height-source: userset" height=22><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: white; WIDTH: 37pt; HEIGHT: 16.5pt; BORDER-TOP: #d9d9d9 0.5pt solid; BORDER-RIGHT: #f0f0f0" class=xl80 height=22 width=49>8</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #d9d9d9 0.5pt solid; BACKGROUND-COLOR: white; WIDTH: 51pt; BORDER-TOP: #d9d9d9 0.5pt solid; BORDER-RIGHT: #f0f0f0" class=xl82 width=68>claire</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #d9d9d9 0.5pt solid; BACKGROUND-COLOR: white; BORDER-TOP: #d9d9d9 0.5pt solid; BORDER-RIGHT: #f0f0f0" class=xl83>a</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #d9d9d9 0.5pt solid; BACKGROUND-COLOR: white; WIDTH: 33pt; BORDER-TOP: #d9d9d9 0.5pt solid; BORDER-RIGHT: #f0f0f0" class=xl84 width=44> </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: white; WIDTH: 32pt; BORDER-TOP: #d9d9d9 0.5pt solid; BORDER-RIGHT: #f0f0f0" class=xl80 width=43> </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #d9d9d9 0.5pt solid; BACKGROUND-COLOR: white; WIDTH: 36pt; BORDER-TOP: #d9d9d9 0.5pt solid; BORDER-RIGHT: #f0f0f0" class=xl84 width=48> </TD></TR><TR style="HEIGHT: 16.5pt; mso-height-source: userset" height=22><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: white; WIDTH: 37pt; HEIGHT: 16.5pt; BORDER-TOP: #d9d9d9 0.5pt solid; BORDER-RIGHT: #f0f0f0" class=xl80 height=22 width=49>9</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #d9d9d9 0.5pt solid; BACKGROUND-COLOR: white; WIDTH: 51pt; BORDER-TOP: #d9d9d9 0.5pt solid; BORDER-RIGHT: #f0f0f0" class=xl82 width=68>ben</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #d9d9d9 0.5pt solid; BACKGROUND-COLOR: white; BORDER-TOP: #d9d9d9 0.5pt solid; BORDER-RIGHT: #f0f0f0" class=xl83>a</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #d9d9d9 0.5pt solid; BACKGROUND-COLOR: white; WIDTH: 33pt; BORDER-TOP: #d9d9d9 0.5pt solid; BORDER-RIGHT: #f0f0f0" class=xl84 width=44> </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: white; WIDTH: 32pt; BORDER-TOP: #d9d9d9 0.5pt solid; BORDER-RIGHT: #f0f0f0" class=xl80 width=43> </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #d9d9d9 0.5pt solid; BACKGROUND-COLOR: white; WIDTH: 36pt; BORDER-TOP: #d9d9d9 0.5pt solid; BORDER-RIGHT: #f0f0f0" class=xl84 width=48> </TD></TR><TR style="HEIGHT: 16.5pt; mso-height-source: userset" height=22><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: white; WIDTH: 37pt; HEIGHT: 16.5pt; BORDER-TOP: #d9d9d9 0.5pt solid; BORDER-RIGHT: #f0f0f0" class=xl80 height=22 width=49>10</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #d9d9d9 0.5pt solid; BACKGROUND-COLOR: white; WIDTH: 51pt; BORDER-TOP: #d9d9d9 0.5pt solid; BORDER-RIGHT: #f0f0f0" class=xl82 width=68>sarah</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #d9d9d9 0.5pt solid; BACKGROUND-COLOR: white; BORDER-TOP: #d9d9d9 0.5pt solid; BORDER-RIGHT: #f0f0f0" class=xl83>a</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #d9d9d9 0.5pt solid; BACKGROUND-COLOR: white; WIDTH: 33pt; BORDER-TOP: #d9d9d9 0.5pt solid; BORDER-RIGHT: #f0f0f0" class=xl84 width=44> </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: white; WIDTH: 32pt; BORDER-TOP: #d9d9d9 0.5pt solid; BORDER-RIGHT: #f0f0f0" class=xl80 width=43> </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #d9d9d9 0.5pt solid; BACKGROUND-COLOR: white; WIDTH: 36pt; BORDER-TOP: #d9d9d9 0.5pt solid; BORDER-RIGHT: #f0f0f0" class=xl84 width=48> </TD></TR></TBODY></TABLE>

Current code to find top 10
=LARGE(IF($D$2:$D$200=Q$5,$F$2:$F$200),ROW(F1)) (shift,cntrl.enter)
then
=INDEX($C$2:$C$200,SMALL(IF($F$2:$F$200=R5,IF($D$2:$D$200=Q5,ROW($D$2:$D$200)-ROW($D$2))),COUNTIF(R$5:R5,$R5)))

Results being returned:- as you can see im only testing A grade atm

<TABLE style="WIDTH: 162pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=216><COLGROUP><COL style="WIDTH: 54pt" span=3 width=72><TBODY><TR style="HEIGHT: 16.5pt; mso-height-source: userset" height=22><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 54pt; HEIGHT: 16.5pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl67 height=22 width=72>Grade</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 54pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl67 width=72>Score</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 54pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl67 width=72>Name</TD></TR><TR style="HEIGHT: 16.5pt; mso-height-source: userset" height=22><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; HEIGHT: 16.5pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl65 height=22>A</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl68>37</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl65>henry</TD></TR><TR style="HEIGHT: 16.5pt; mso-height-source: userset" height=22><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; HEIGHT: 16.5pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl65 height=22>A</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl68>31</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl65>joshua</TD></TR><TR style="HEIGHT: 16.5pt; mso-height-source: userset" height=22><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; HEIGHT: 16.5pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl66 height=22>A</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl68>31</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl65>ben</TD></TR><TR style="HEIGHT: 16.5pt; mso-height-source: userset" height=22><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; HEIGHT: 16.5pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl66 height=22>A</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl68>30</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl65>fred</TD></TR><TR style="HEIGHT: 16.5pt; mso-height-source: userset" height=22><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; HEIGHT: 16.5pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl66 height=22>A</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl68>30</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl65>ben</TD></TR><TR style="HEIGHT: 16.5pt; mso-height-source: userset" height=22><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; HEIGHT: 16.5pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl66 height=22>A</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl68>26</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl65>claire</TD></TR><TR style="HEIGHT: 16.5pt; mso-height-source: userset" height=22><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; HEIGHT: 16.5pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl66 height=22>A</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl68>25</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl65>fred</TD></TR><TR style="HEIGHT: 16.5pt; mso-height-source: userset" height=22><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; HEIGHT: 16.5pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl66 height=22>A</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl68>25</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl65>henry</TD></TR><TR style="HEIGHT: 16.5pt" height=22><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; HEIGHT: 16.5pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl66 height=22>A</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl68>25</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl65>sarah</TD></TR><TR style="HEIGHT: 16.5pt" height=22><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; HEIGHT: 16.5pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl66 height=22>A</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl68>24</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl65>bob</TD></TR></TBODY></TABLE>

 

[Robert Mika]

What's in R5 and Q5?
What in column D?
The top table does not corespond to your results.