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>

 

[confusedjo]

Guessing this is my problem - I have been working on this for some time and columns and rows are merging together

Q5:Q15 = A for grade A
R = Score
S = name (that i am trying to match with the score)
Col D is currently nothing but may be used later as a special Grade (veterns, junior etc)

I hope you can understand this - as im stuggling to understand my own work.
Thank you for your time!

 

[confusedjo]

I Think I have found a solution:-
*Note1 =LARGE(IF($D$2:$D$200="A",F$2:F$200),1) in score column (R) of sorted table to find score
*Note 2=INDEX($C$2:$C$200,SMALL(IF($F$2:$F$200=R3,ROW($F$2:$F$200)-ROW($F$2)+1),COUNTIF(R$3:R3,R3))) in name column (S) of sorted table to find name to match the score
All Array formulas.

Orginal data =
A1 = Shooter Name, C1= Name, D1= Grade, F1=Score 50, G1= Score501 onwards until N= Day Total ( I had to remove the other totals i had throughout the table.

Sorted Data =
Q=Grade (currently A)
R= Score *note 1
S= Name *note 2


Would be greatful for any feedback - and i am also wondering if it would be possible to find the top 10 (for example) from all scores depending on there grade, i am able to do without having grade as a condition.
Thanks for your help!!

 

[confusedjo]

I Think I have found a solution:-
*Note1 =LARGE(IF($D$2:$D$200="A",F$2:F$200),1) in score column (R) of sorted table to find score
*Note 2=INDEX($C$2:$C$200,SMALL(IF($F$2:$F$200=R3,ROW($F$2:$F$200)-ROW($F$2)+1),COUNTIF(R$3:R3,R3))) in name column (S) of sorted table to find name to match the score
All Array formulas.

Orginal data =
A1 = Shooter Name, C1= Name, D1= Grade, F1=Score 50, G1= Score501 onwards until N= Day Total ( I had to remove the other totals i had throughout the table.

Sorted Data =
Q=Grade (currently A)
R= Score *note 1
S= Name *note 2


Would be greatful for any feedback - and i am also wondering if it would be possible to find the top 10 (for example) from all scores depending on there grade, i am able to do without having grade as a condition.
Thanks for your help!!

 

[confusedjo]

oops didnt mean to send this twice - newby status is growing.