Group Ranking Formula

B

Biz

Well-known Member
Joined
May 18, 2009
Messages
1,773
Office Version
  1. 2021
Platform
  1. Windows
Dear All,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:eek:ffice:eek:ffice" /><o:p></o:p>
<o:p></o:p>
I have created auto sort formula based on criteria’s P11:Q15.<o:p></o:p>
Formulas work except Grand Ranking Formula is very long. Is there better way?
Please no array formula Ctrl+Shift+Enter, no macros or UDFs.


<o:p></o:p>
Cell AG12<o:p></o:p>
=AA12*100000000000+AB12*1000000000+AD12*1000000+AE12*1000+AF12<o:p></o:p>
<o:p></o:p>
<o:p>Sheet1


<TABLE style="BACKGROUND-COLOR: #ffffff; PADDING-LEFT: 2pt; PADDING-RIGHT: 2pt; FONT-FAMILY: Arial,Arial; FONT-SIZE: 8pt" border=1 cellSpacing=0 cellPadding=0><COLGROUP><COL style="WIDTH: 30px; FONT-WEIGHT: bold"><COL style="WIDTH: 56px"><COL style="WIDTH: 56px"><COL style="WIDTH: 56px"><COL style="WIDTH: 89px"><COL style="WIDTH: 67px"><COL style="WIDTH: 64px"><COL style="WIDTH: 45px"></COLGROUP><TBODY><TR style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt; FONT-WEIGHT: bold"><TD></TD><TD>C</TD><TD>D</TD><TD>E</TD><TD>F</TD><TD>G</TD><TD>H</TD><TD>I</TD></TR><TR style="HEIGHT: 19px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">9</TD><TD style="BACKGROUND-COLOR: #ffff00">Unordered List</TD><TD style="BACKGROUND-COLOR: #ffff00"></TD><TD style="BACKGROUND-COLOR: #ffff00"></TD><TD style="BACKGROUND-COLOR: #ffff00"></TD><TD style="BACKGROUND-COLOR: #ffff00"></TD><TD style="BACKGROUND-COLOR: #ffff00"></TD><TD style="BACKGROUND-COLOR: #ffff00"></TD></TR><TR style="HEIGHT: 19px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">10</TD><TD style="BACKGROUND-COLOR: #ffff00"></TD><TD style="BACKGROUND-COLOR: #ffff00"></TD><TD style="BACKGROUND-COLOR: #ffff00"></TD><TD style="BACKGROUND-COLOR: #ffff00"></TD><TD style="BACKGROUND-COLOR: #ffff00"></TD><TD style="BACKGROUND-COLOR: #ffff00"></TD><TD style="BACKGROUND-COLOR: #ffff00"></TD></TR><TR style="HEIGHT: 19px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">11</TD><TD style="BACKGROUND-COLOR: #ffff00"></TD><TD style="BACKGROUND-COLOR: #ffff00"></TD><TD style="BACKGROUND-COLOR: #ffff00"></TD><TD style="BACKGROUND-COLOR: #ffff00">Name</TD><TD style="BACKGROUND-COLOR: #ffff00">Date of Birth</TD><TD style="BACKGROUND-COLOR: #ffff00">Occupation</TD><TD style="BACKGROUND-COLOR: #ffff00">Ranking</TD></TR><TR style="HEIGHT: 19px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">12</TD><TD style="BACKGROUND-COLOR: #ffff00"></TD><TD style="BACKGROUND-COLOR: #ffff00"></TD><TD style="BACKGROUND-COLOR: #ffff00"></TD><TD style="BACKGROUND-COLOR: #ffff00">Nasser Broke</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00">05-Sep-77</TD><TD style="BACKGROUND-COLOR: #ffff00">Astronaut</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00">7</TD></TR><TR style="HEIGHT: 19px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">13</TD><TD style="BACKGROUND-COLOR: #ffff00"></TD><TD style="BACKGROUND-COLOR: #ffff00"></TD><TD style="BACKGROUND-COLOR: #ffff00"></TD><TD style="BACKGROUND-COLOR: #ffff00">Eamonn Adder</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00">17-Sep-67</TD><TD style="BACKGROUND-COLOR: #ffff00">Accountant</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00">4</TD></TR><TR style="HEIGHT: 19px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">14</TD><TD style="BACKGROUND-COLOR: #ffff00"></TD><TD style="BACKGROUND-COLOR: #ffff00"></TD><TD style="BACKGROUND-COLOR: #ffff00"></TD><TD style="BACKGROUND-COLOR: #ffff00">John Deed</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00">04-May-06</TD><TD style="BACKGROUND-COLOR: #ffff00">Judge</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00">8</TD></TR><TR style="HEIGHT: 19px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">15</TD><TD style="BACKGROUND-COLOR: #ffff00"></TD><TD style="BACKGROUND-COLOR: #ffff00"></TD><TD style="BACKGROUND-COLOR: #ffff00"></TD><TD style="BACKGROUND-COLOR: #ffff00">Ivan Opinion</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00">01-Dec-74</TD><TD style="BACKGROUND-COLOR: #ffff00">Jurist</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00">10</TD></TR><TR style="HEIGHT: 19px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">16</TD><TD style="BACKGROUND-COLOR: #ffff00"></TD><TD style="BACKGROUND-COLOR: #ffff00"></TD><TD style="BACKGROUND-COLOR: #ffff00"></TD><TD style="BACKGROUND-COLOR: #ffff00">Armin Sling</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00">03-Aug-52</TD><TD style="BACKGROUND-COLOR: #ffff00">Executioner</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00">5</TD></TR><TR style="HEIGHT: 19px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">17</TD><TD style="BACKGROUND-COLOR: #ffff00"></TD><TD style="BACKGROUND-COLOR: #ffff00"></TD><TD style="BACKGROUND-COLOR: #ffff00"></TD><TD style="BACKGROUND-COLOR: #ffff00">Gus Again</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00">05-Jun-78</TD><TD style="BACKGROUND-COLOR: #ffff00">Accountant</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00">3</TD></TR><TR style="HEIGHT: 19px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">18</TD><TD style="BACKGROUND-COLOR: #ffff00"></TD><TD style="BACKGROUND-COLOR: #ffff00"></TD><TD style="BACKGROUND-COLOR: #ffff00"></TD><TD style="BACKGROUND-COLOR: #ffff00">Miss Take</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00">30-Aug-72</TD><TD style="BACKGROUND-COLOR: #ffff00">Teacher</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00">7</TD></TR><TR style="HEIGHT: 19px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">19</TD><TD style="BACKGROUND-COLOR: #ffff00"></TD><TD style="BACKGROUND-COLOR: #ffff00"></TD><TD style="BACKGROUND-COLOR: #ffff00"></TD><TD style="BACKGROUND-COLOR: #ffff00">Woody Plane</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00">16-Jan-48</TD><TD style="BACKGROUND-COLOR: #ffff00">Carpenter</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00">8</TD></TR><TR style="HEIGHT: 19px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">20</TD><TD style="BACKGROUND-COLOR: #ffff00"></TD><TD style="BACKGROUND-COLOR: #ffff00"></TD><TD style="BACKGROUND-COLOR: #ffff00"></TD><TD style="BACKGROUND-COLOR: #ffff00">John Smith</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00">05-Jun-78</TD><TD style="BACKGROUND-COLOR: #ffff00">Blacksmith</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00">6</TD></TR><TR style="HEIGHT: 19px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">21</TD><TD style="BACKGROUND-COLOR: #ffff00"></TD><TD style="BACKGROUND-COLOR: #ffff00"></TD><TD style="BACKGROUND-COLOR: #ffff00"></TD><TD style="BACKGROUND-COLOR: #ffff00">John Smith</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00">05-Jun-78</TD><TD style="BACKGROUND-COLOR: #ffff00">Blacksmith</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00">5</TD></TR><TR style="HEIGHT: 19px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">22</TD><TD style="BACKGROUND-COLOR: #ffff00"></TD><TD style="BACKGROUND-COLOR: #ffff00"></TD><TD style="BACKGROUND-COLOR: #ffff00"></TD><TD style="BACKGROUND-COLOR: #ffff00">Kyle Mockingbird</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00">01-Jul-60</TD><TD style="BACKGROUND-COLOR: #ffff00">Lawyer</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00">9</TD></TR><TR style="HEIGHT: 19px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">23</TD><TD style="BACKGROUND-COLOR: #ffff00"></TD><TD style="BACKGROUND-COLOR: #ffff00"></TD><TD style="BACKGROUND-COLOR: #ffff00"></TD><TD style="BACKGROUND-COLOR: #ffff00">Indra Flora</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00">24-Mar-69</TD><TD style="BACKGROUND-COLOR: #ffff00">Florist</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00">7</TD></TR><TR style="HEIGHT: 19px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">24</TD><TD style="BACKGROUND-COLOR: #ffff00"></TD><TD style="BACKGROUND-COLOR: #ffff00"></TD><TD style="BACKGROUND-COLOR: #ffff00"></TD><TD style="BACKGROUND-COLOR: #ffff00">Joe Smith</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00">07-Dec-80</TD><TD style="BACKGROUND-COLOR: #ffff00">Footballer</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00">8</TD></TR><TR style="HEIGHT: 19px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">25</TD><TD style="BACKGROUND-COLOR: #ffff00"></TD><TD style="BACKGROUND-COLOR: #ffff00"></TD><TD style="BACKGROUND-COLOR: #ffff00"></TD><TD style="BACKGROUND-COLOR: #ffff00">Jane Bond</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00">04-Jan-00</TD><TD style="BACKGROUND-COLOR: #ffff00">Assassin</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00">3</TD></TR><TR style="HEIGHT: 19px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">26</TD><TD style="BACKGROUND-COLOR: #ffff00"></TD><TD style="BACKGROUND-COLOR: #ffff00"></TD><TD style="BACKGROUND-COLOR: #ffff00"></TD><TD style="BACKGROUND-COLOR: #ffff00">Adele</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00">05-May-88</TD><TD style="BACKGROUND-COLOR: #ffff00">Musician</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00">8</TD></TR><TR style="HEIGHT: 19px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">27</TD><TD style="BACKGROUND-COLOR: #ffff00"></TD><TD style="BACKGROUND-COLOR: #ffff00"></TD><TD style="BACKGROUND-COLOR: #ffff00"></TD><TD style="BACKGROUND-COLOR: #ffff00">Doctor Who</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00">01-Jan-00</TD><TD style="BACKGROUND-COLOR: #ffff00">Time Lord</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00">10</TD></TR><TR style="HEIGHT: 19px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">28</TD><TD style="BACKGROUND-COLOR: #ffff00"></TD><TD style="BACKGROUND-COLOR: #ffff00"></TD><TD style="BACKGROUND-COLOR: #ffff00"></TD><TD style="BACKGROUND-COLOR: #ffff00">Number Six</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00">06-Jun-66</TD><TD style="BACKGROUND-COLOR: #ffff00">Prisoner</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00">1</TD></TR><TR style="HEIGHT: 19px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">29</TD><TD style="BACKGROUND-COLOR: #ffff00"></TD><TD style="BACKGROUND-COLOR: #ffff00"></TD><TD style="BACKGROUND-COLOR: #ffff00"></TD><TD style="BACKGROUND-COLOR: #ffff00">Paris Shilton</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00">04-May-59</TD><TD style="BACKGROUND-COLOR: #ffff00">No Idea</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00">4</TD></TR><TR style="HEIGHT: 19px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">30</TD><TD style="BACKGROUND-COLOR: #ffff00"></TD><TD style="BACKGROUND-COLOR: #ffff00"></TD><TD style="BACKGROUND-COLOR: #ffff00"></TD><TD style="BACKGROUND-COLOR: #ffff00">Lorraine N'Spain</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00">29-Apr-58</TD><TD style="BACKGROUND-COLOR: #ffff00">Fair Lady</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00">7</TD></TR><TR style="HEIGHT: 19px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">31</TD><TD style="BACKGROUND-COLOR: #ffff00"></TD><TD style="BACKGROUND-COLOR: #ffff00"></TD><TD style="BACKGROUND-COLOR: #ffff00"></TD><TD style="BACKGROUND-COLOR: #ffff00">Herr Fixx</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00">02-Aug-39</TD><TD style="BACKGROUND-COLOR: #ffff00">Model</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00">6</TD></TR><TR style="HEIGHT: 19px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">32</TD><TD style="BACKGROUND-COLOR: #ffff00"></TD><TD style="BACKGROUND-COLOR: #ffff00"></TD><TD style="BACKGROUND-COLOR: #ffff00"></TD><TD style="BACKGROUND-COLOR: #ffff00"></TD><TD style="BACKGROUND-COLOR: #ffff00"></TD><TD style="BACKGROUND-COLOR: #ffff00"></TD><TD style="BACKGROUND-COLOR: #ffff00"></TD></TR><TR style="HEIGHT: 19px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">33</TD><TD style="BACKGROUND-COLOR: #ffff00"></TD><TD style="BACKGROUND-COLOR: #ffff00"></TD><TD style="BACKGROUND-COLOR: #ffff00"></TD><TD style="BACKGROUND-COLOR: #ffff00"></TD><TD style="BACKGROUND-COLOR: #ffff00"></TD><TD style="BACKGROUND-COLOR: #ffff00"></TD><TD style="BACKGROUND-COLOR: #ffff00"></TD></TR><TR style="HEIGHT: 19px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">34</TD><TD style="BACKGROUND-COLOR: #ffff00"></TD><TD style="BACKGROUND-COLOR: #ffff00"></TD><TD style="BACKGROUND-COLOR: #ffff00"></TD><TD style="BACKGROUND-COLOR: #ffff00"></TD><TD style="BACKGROUND-COLOR: #ffff00"></TD><TD style="BACKGROUND-COLOR: #ffff00"></TD><TD style="BACKGROUND-COLOR: #ffff00"></TD></TR></TBODY></TABLE>

Sheet1

<TABLE style="BACKGROUND-COLOR: #ffffff; PADDING-LEFT: 2pt; PADDING-RIGHT: 2pt; FONT-FAMILY: Arial,Arial; FONT-SIZE: 8pt" border=1 cellSpacing=0 cellPadding=0><COLGROUP><COL style="WIDTH: 30px; FONT-WEIGHT: bold"><COL style="WIDTH: 56px"><COL style="WIDTH: 134px"><COL style="WIDTH: 26px"></COLGROUP><TBODY><TR style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt; FONT-WEIGHT: bold"><TD></TD><TD>O</TD><TD>P</TD><TD>Q</TD></TR><TR style="HEIGHT: 19px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">10</TD><TD style="BACKGROUND-COLOR: #ff6600"></TD><TD style="BACKGROUND-COLOR: #ff6600">Sort Order</TD><TD style="BACKGROUND-COLOR: #ff6600"></TD></TR><TR style="HEIGHT: 19px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">11</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ff6600">1</TD><TD style="BACKGROUND-COLOR: #ff6600">Surname</TD><TD style="BACKGROUND-COLOR: #ff6600">A-Z</TD></TR><TR style="HEIGHT: 19px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">12</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ff6600">2</TD><TD style="BACKGROUND-COLOR: #ff6600">Forename</TD><TD style="BACKGROUND-COLOR: #ff6600">A-Z</TD></TR><TR style="HEIGHT: 19px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">13</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ff6600">3</TD><TD style="BACKGROUND-COLOR: #ff6600">DOB</TD><TD style="BACKGROUND-COLOR: #ff6600">Z-A</TD></TR><TR style="HEIGHT: 19px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">14</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ff6600">4</TD><TD style="BACKGROUND-COLOR: #ff6600">Occupation Fourth</TD><TD style="BACKGROUND-COLOR: #ff6600">A-Z</TD></TR><TR style="HEIGHT: 19px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">15</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ff6600">5</TD><TD style="BACKGROUND-COLOR: #ff6600">Ranking Highest - Lowest</TD><TD style="BACKGROUND-COLOR: #ff6600">Z-A</TD></TR></TBODY></TABLE>
</o:p><o:p></o:p>
<o:p></o:p>
<o:p>Sheet1

<TABLE style="BACKGROUND-COLOR: #ffffff; PADDING-LEFT: 2pt; PADDING-RIGHT: 2pt; FONT-FAMILY: Arial,Arial; FONT-SIZE: 8pt" border=1 cellSpacing=0 cellPadding=0><COLGROUP><COL style="WIDTH: 30px; FONT-WEIGHT: bold"><COL style="WIDTH: 56px"><COL style="WIDTH: 56px"><COL style="WIDTH: 56px"><COL style="WIDTH: 56px"><COL style="WIDTH: 56px"><COL style="WIDTH: 56px"><COL style="WIDTH: 56px"><COL style="WIDTH: 56px"><COL style="WIDTH: 89px"><COL style="WIDTH: 101px"><COL style="WIDTH: 125px"><COL style="WIDTH: 137px"><COL style="WIDTH: 101px"><COL style="WIDTH: 56px"><COL style="WIDTH: 107px"><COL style="WIDTH: 99px"><COL style="WIDTH: 89px"><COL style="WIDTH: 74px"><COL style="WIDTH: 56px"><COL style="WIDTH: 56px"></COLGROUP><TBODY><TR style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt; FONT-WEIGHT: bold"><TD></TD><TD>S</TD><TD>T</TD><TD>U</TD><TD>V</TD><TD>W</TD><TD>X</TD><TD>Y</TD><TD>Z</TD><TD>AA</TD><TD>AB</TD><TD>AC</TD><TD>AD</TD><TD>AE</TD><TD>AF</TD><TD>AG</TD><TD>AH</TD><TD>AI</TD><TD>AJ</TD><TD>AK</TD><TD>AL</TD></TR><TR style="HEIGHT: 19px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">11</TD><TD style="BACKGROUND-COLOR: #008080; FONT-WEIGHT: bold">Surname</TD><TD style="BACKGROUND-COLOR: #008080; FONT-WEIGHT: bold">First Name</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD style="BACKGROUND-COLOR: #c0c0c0">Sort by Surname</TD><TD style="BACKGROUND-COLOR: #c0c0c0">Sort by First Name</TD><TD style="BACKGROUND-COLOR: #ffcc00">Sort Order By Full Name</TD><TD style="BACKGROUND-COLOR: #00ccff">Unique Sort Order by DOB</TD><TD style="BACKGROUND-COLOR: #808000">Sort by Occupation</TD><TD style="BACKGROUND-COLOR: #808080">Ranking</TD><TD style="FONT-WEIGHT: bold">Grand Ranking</TD><TD style="FONT-WEIGHT: bold">A-Z Ranking Order</TD><TD style="BACKGROUND-COLOR: #ffcc00; FONT-WEIGHT: bold">Final Solution</TD><TD style="BACKGROUND-COLOR: #ffcc00; FONT-WEIGHT: bold">Date of Birth</TD><TD style="BACKGROUND-COLOR: #ffcc00; FONT-WEIGHT: bold">Occupation</TD><TD style="BACKGROUND-COLOR: #ffcc00; FONT-WEIGHT: bold">Ranking</TD></TR><TR style="HEIGHT: 19px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">12</TD><TD>Broke</TD><TD>Nasser</TD><TD>Nasser Broke</TD><TD></TD><TD></TD><TD>Adele</TD><TD>Adele </TD><TD></TD><TD style="TEXT-ALIGN: right">4</TD><TD style="TEXT-ALIGN: right">16</TD><TD style="TEXT-ALIGN: right">16</TD><TD style="TEXT-ALIGN: right">7</TD><TD style="TEXT-ALIGN: right">3</TD><TD style="TEXT-ALIGN: right">9</TD><TD style="TEXT-ALIGN: right">416,007,003,009 </TD><TD style="TEXT-ALIGN: right">5 </TD><TD>Adele</TD><TD style="TEXT-ALIGN: right">05-May-88</TD><TD>Musician</TD><TD style="TEXT-ALIGN: right">8</TD></TR><TR style="HEIGHT: 19px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">13</TD><TD>Adder</TD><TD>Eamonn</TD><TD>Eamonn Adder</TD><TD></TD><TD>Sling</TD><TD>Armin</TD><TD>Armin Sling</TD><TD></TD><TD style="TEXT-ALIGN: right">1</TD><TD style="TEXT-ALIGN: right">3</TD><TD style="TEXT-ALIGN: right">3</TD><TD style="TEXT-ALIGN: right">11</TD><TD style="TEXT-ALIGN: right">0</TD><TD style="TEXT-ALIGN: right">3</TD><TD style="TEXT-ALIGN: right">103,011,000,003 </TD><TD style="TEXT-ALIGN: right">2 </TD><TD>Eamonn Adder</TD><TD style="TEXT-ALIGN: right">17-Sep-67</TD><TD>Accountant</TD><TD style="TEXT-ALIGN: right">4</TD></TR><TR style="HEIGHT: 19px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">14</TD><TD>Deed</TD><TD>John</TD><TD>John Deed</TD><TD></TD><TD>Who</TD><TD>Doctor</TD><TD>Doctor Who</TD><TD></TD><TD style="TEXT-ALIGN: right">5</TD><TD style="TEXT-ALIGN: right">10</TD><TD style="TEXT-ALIGN: right">10</TD><TD style="TEXT-ALIGN: right">1</TD><TD style="TEXT-ALIGN: right">11</TD><TD style="TEXT-ALIGN: right">13</TD><TD style="TEXT-ALIGN: right">510,001,011,013 </TD><TD style="TEXT-ALIGN: right">6 </TD><TD>Gus Again</TD><TD style="TEXT-ALIGN: right">05-Jun-78</TD><TD>Accountant</TD><TD style="TEXT-ALIGN: right">3</TD></TR><TR style="HEIGHT: 19px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">15</TD><TD>Opinion</TD><TD>Ivan</TD><TD>Ivan Opinion</TD><TD></TD><TD>Adder</TD><TD>Eamonn</TD><TD>Eamonn Adder</TD><TD></TD><TD style="TEXT-ALIGN: right">10</TD><TD style="TEXT-ALIGN: right">7</TD><TD style="TEXT-ALIGN: right">7</TD><TD style="TEXT-ALIGN: right">8</TD><TD style="TEXT-ALIGN: right">12</TD><TD style="TEXT-ALIGN: right">18</TD><TD style="TEXT-ALIGN: right">1,007,008,012,018 </TD><TD style="TEXT-ALIGN: right">11 </TD><TD>Jane Bond</TD><TD style="TEXT-ALIGN: right">04-Jan-00</TD><TD>Assassin</TD><TD style="TEXT-ALIGN: right">3</TD></TR><TR style="HEIGHT: 19px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">16</TD><TD>Sling</TD><TD>Armin</TD><TD>Armin Sling</TD><TD></TD><TD>Again</TD><TD>Gus</TD><TD>Gus Again</TD><TD></TD><TD style="TEXT-ALIGN: right">14</TD><TD style="TEXT-ALIGN: right">1</TD><TD style="TEXT-ALIGN: right">1</TD><TD style="TEXT-ALIGN: right">16</TD><TD style="TEXT-ALIGN: right">7</TD><TD style="TEXT-ALIGN: right">5</TD><TD style="TEXT-ALIGN: right">1,401,016,007,005 </TD><TD style="TEXT-ALIGN: right">15 </TD><TD>Nasser Broke</TD><TD style="TEXT-ALIGN: right">05-Sep-77</TD><TD>Astronaut</TD><TD style="TEXT-ALIGN: right">7</TD></TR><TR style="HEIGHT: 19px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">17</TD><TD>Again</TD><TD>Gus</TD><TD>Gus Again</TD><TD></TD><TD>Fixx</TD><TD>Herr</TD><TD>Herr Fixx</TD><TD></TD><TD style="TEXT-ALIGN: right">2</TD><TD style="TEXT-ALIGN: right">4</TD><TD style="TEXT-ALIGN: right">4</TD><TD style="TEXT-ALIGN: right">4</TD><TD style="TEXT-ALIGN: right">0</TD><TD style="TEXT-ALIGN: right">1</TD><TD style="TEXT-ALIGN: right">204,004,000,001 </TD><TD style="TEXT-ALIGN: right">3 </TD><TD>John Deed</TD><TD style="TEXT-ALIGN: right">04-May-06</TD><TD>Judge</TD><TD style="TEXT-ALIGN: right">8</TD></TR><TR style="HEIGHT: 19px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">18</TD><TD>Take</TD><TD>Miss</TD><TD>Miss Take</TD><TD></TD><TD>Flora</TD><TD>Indra</TD><TD>Indra Flora</TD><TD></TD><TD style="TEXT-ALIGN: right">18</TD><TD style="TEXT-ALIGN: right">15</TD><TD style="TEXT-ALIGN: right">15</TD><TD style="TEXT-ALIGN: right">9</TD><TD style="TEXT-ALIGN: right">18</TD><TD style="TEXT-ALIGN: right">9</TD><TD style="TEXT-ALIGN: right">1,815,009,018,009 </TD><TD style="TEXT-ALIGN: right">19 </TD><TD>Herr Fixx</TD><TD style="TEXT-ALIGN: right">02-Aug-39</TD><TD>Model</TD><TD style="TEXT-ALIGN: right">6</TD></TR><TR style="HEIGHT: 19px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">19</TD><TD>Plane</TD><TD>Woody</TD><TD>Woody Plane</TD><TD></TD><TD>Opinion</TD><TD>Ivan</TD><TD>Ivan Opinion</TD><TD></TD><TD style="TEXT-ALIGN: right">11</TD><TD style="TEXT-ALIGN: right">19</TD><TD style="TEXT-ALIGN: right">19</TD><TD style="TEXT-ALIGN: right">17</TD><TD style="TEXT-ALIGN: right">6</TD><TD style="TEXT-ALIGN: right">13</TD><TD style="TEXT-ALIGN: right">1,119,017,006,013 </TD><TD style="TEXT-ALIGN: right">12 </TD><TD>Indra Flora</TD><TD style="TEXT-ALIGN: right">24-Mar-69</TD><TD>Florist</TD><TD style="TEXT-ALIGN: right">7</TD></TR><TR style="HEIGHT: 19px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">20</TD><TD>Smith</TD><TD>John</TD><TD>John Smith</TD><TD></TD><TD>Bond</TD><TD>Jane</TD><TD>Jane Bond</TD><TD></TD><TD style="TEXT-ALIGN: right">15</TD><TD style="TEXT-ALIGN: right">10</TD><TD style="TEXT-ALIGN: right">11</TD><TD style="TEXT-ALIGN: right">5</TD><TD style="TEXT-ALIGN: right">4</TD><TD style="TEXT-ALIGN: right">7</TD><TD style="TEXT-ALIGN: right">1,510,005,004,007 </TD><TD style="TEXT-ALIGN: right">17 </TD><TD>Kyle Mockingbird</TD><TD style="TEXT-ALIGN: right">01-Jul-60</TD><TD>Lawyer</TD><TD style="TEXT-ALIGN: right">9</TD></TR><TR style="HEIGHT: 19px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">21</TD><TD>Smith</TD><TD>John</TD><TD>John Smith</TD><TD></TD><TD>Smith</TD><TD>Joe</TD><TD>Joe Smith</TD><TD></TD><TD style="TEXT-ALIGN: right">15</TD><TD style="TEXT-ALIGN: right">10</TD><TD style="TEXT-ALIGN: right">11</TD><TD style="TEXT-ALIGN: right">6</TD><TD style="TEXT-ALIGN: right">4</TD><TD style="TEXT-ALIGN: right">5</TD><TD style="TEXT-ALIGN: right">1,510,006,004,005 </TD><TD style="TEXT-ALIGN: right">18 </TD><TD>Lorraine N'Spain</TD><TD style="TEXT-ALIGN: right">29-Apr-58</TD><TD>Fair Lady</TD><TD style="TEXT-ALIGN: right">7</TD></TR><TR style="HEIGHT: 19px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">22</TD><TD>Mockingbird</TD><TD>Kyle</TD><TD>Kyle Mockingbird</TD><TD></TD><TD>Deed</TD><TD>John</TD><TD>John Deed</TD><TD></TD><TD style="TEXT-ALIGN: right">8</TD><TD style="TEXT-ALIGN: right">13</TD><TD style="TEXT-ALIGN: right">13</TD><TD style="TEXT-ALIGN: right">13</TD><TD style="TEXT-ALIGN: right">13</TD><TD style="TEXT-ALIGN: right">17</TD><TD style="TEXT-ALIGN: right">813,013,013,017 </TD><TD style="TEXT-ALIGN: right">9 </TD><TD>Ivan Opinion</TD><TD style="TEXT-ALIGN: right">01-Dec-74</TD><TD>Jurist</TD><TD style="TEXT-ALIGN: right">10</TD></TR><TR style="HEIGHT: 19px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">23</TD><TD>Flora</TD><TD>Indra</TD><TD>Indra Flora</TD><TD></TD><TD>Smith</TD><TD>John</TD><TD>John Smith</TD><TD></TD><TD style="TEXT-ALIGN: right">7</TD><TD style="TEXT-ALIGN: right">6</TD><TD style="TEXT-ALIGN: right">6</TD><TD style="TEXT-ALIGN: right">10</TD><TD style="TEXT-ALIGN: right">9</TD><TD style="TEXT-ALIGN: right">9</TD><TD style="TEXT-ALIGN: right">706,010,009,009 </TD><TD style="TEXT-ALIGN: right">8 </TD><TD>Woody Plane</TD><TD style="TEXT-ALIGN: right">16-Jan-48</TD><TD>Carpenter</TD><TD style="TEXT-ALIGN: right">8</TD></TR><TR style="HEIGHT: 19px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">24</TD><TD>Smith</TD><TD>Joe</TD><TD>Joe Smith</TD><TD></TD><TD>Smith</TD><TD>John</TD><TD>John Smith</TD><TD></TD><TD style="TEXT-ALIGN: right">15</TD><TD style="TEXT-ALIGN: right">9</TD><TD style="TEXT-ALIGN: right">9</TD><TD style="TEXT-ALIGN: right">3</TD><TD style="TEXT-ALIGN: right">10</TD><TD style="TEXT-ALIGN: right">13</TD><TD style="TEXT-ALIGN: right">1,509,003,010,013 </TD><TD style="TEXT-ALIGN: right">16 </TD><TD>Paris Shilton</TD><TD style="TEXT-ALIGN: right">04-May-59</TD><TD>No Idea</TD><TD style="TEXT-ALIGN: right">4</TD></TR><TR style="HEIGHT: 19px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">25</TD><TD>Bond</TD><TD>Jane</TD><TD>Jane Bond</TD><TD></TD><TD>Mockingbird</TD><TD>Kyle</TD><TD>Kyle Mockingbird</TD><TD></TD><TD style="TEXT-ALIGN: right">3</TD><TD style="TEXT-ALIGN: right">8</TD><TD style="TEXT-ALIGN: right">8</TD><TD style="TEXT-ALIGN: right">19</TD><TD style="TEXT-ALIGN: right">2</TD><TD style="TEXT-ALIGN: right">1</TD><TD style="TEXT-ALIGN: right">308,019,002,001 </TD><TD style="TEXT-ALIGN: right">4 </TD><TD>Number Six</TD><TD style="TEXT-ALIGN: right">06-Jun-66</TD><TD>Prisoner</TD><TD style="TEXT-ALIGN: right">1</TD></TR><TR style="HEIGHT: 19px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">26</TD><TD></TD><TD>Adele</TD><TD>Adele </TD><TD></TD><TD>N'Spain</TD><TD>Lorraine</TD><TD>Lorraine N'Spain</TD><TD></TD><TD style="TEXT-ALIGN: right">0</TD><TD style="TEXT-ALIGN: right">0</TD><TD style="TEXT-ALIGN: right">0</TD><TD style="TEXT-ALIGN: right">2</TD><TD style="TEXT-ALIGN: right">15</TD><TD style="TEXT-ALIGN: right">13</TD><TD style="TEXT-ALIGN: right">2,015,013 </TD><TD style="TEXT-ALIGN: right">1 </TD><TD>Armin Sling</TD><TD style="TEXT-ALIGN: right">03-Aug-52</TD><TD>Executioner</TD><TD style="TEXT-ALIGN: right">5</TD></TR><TR style="HEIGHT: 19px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">27</TD><TD>Who</TD><TD>Doctor</TD><TD>Doctor Who</TD><TD></TD><TD>Take</TD><TD>Miss</TD><TD>Miss Take</TD><TD></TD><TD style="TEXT-ALIGN: right">19</TD><TD style="TEXT-ALIGN: right">2</TD><TD style="TEXT-ALIGN: right">2</TD><TD style="TEXT-ALIGN: right">20</TD><TD style="TEXT-ALIGN: right">19</TD><TD style="TEXT-ALIGN: right">18</TD><TD style="TEXT-ALIGN: right">1,902,020,019,018 </TD><TD style="TEXT-ALIGN: right">20 </TD><TD>Joe Smith</TD><TD style="TEXT-ALIGN: right">07-Dec-80</TD><TD>Footballer</TD><TD style="TEXT-ALIGN: right">8</TD></TR><TR style="HEIGHT: 19px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">28</TD><TD>Six</TD><TD>Number</TD><TD>Number Six</TD><TD></TD><TD>Broke</TD><TD>Nasser</TD><TD>Nasser Broke</TD><TD></TD><TD style="TEXT-ALIGN: right">13</TD><TD style="TEXT-ALIGN: right">17</TD><TD style="TEXT-ALIGN: right">17</TD><TD style="TEXT-ALIGN: right">12</TD><TD style="TEXT-ALIGN: right">17</TD><TD style="TEXT-ALIGN: right">0</TD><TD style="TEXT-ALIGN: right">1,317,012,017,000 </TD><TD style="TEXT-ALIGN: right">14 </TD><TD>John Smith</TD><TD style="TEXT-ALIGN: right">05-Jun-78</TD><TD>Blacksmith</TD><TD style="TEXT-ALIGN: right">6</TD></TR><TR style="HEIGHT: 19px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">29</TD><TD>Shilton</TD><TD>Paris</TD><TD>Paris Shilton</TD><TD></TD><TD>Six</TD><TD>Number</TD><TD>Number Six</TD><TD></TD><TD style="TEXT-ALIGN: right">12</TD><TD style="TEXT-ALIGN: right">18</TD><TD style="TEXT-ALIGN: right">18</TD><TD style="TEXT-ALIGN: right">14</TD><TD style="TEXT-ALIGN: right">16</TD><TD style="TEXT-ALIGN: right">3</TD><TD style="TEXT-ALIGN: right">1,218,014,016,003 </TD><TD style="TEXT-ALIGN: right">13 </TD><TD>John Smith</TD><TD style="TEXT-ALIGN: right">05-Jun-78</TD><TD>Blacksmith</TD><TD style="TEXT-ALIGN: right">5</TD></TR><TR style="HEIGHT: 19px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">30</TD><TD>N'Spain</TD><TD>Lorraine</TD><TD>Lorraine N'Spain</TD><TD></TD><TD>Shilton</TD><TD>Paris</TD><TD>Paris Shilton</TD><TD></TD><TD style="TEXT-ALIGN: right">9</TD><TD style="TEXT-ALIGN: right">14</TD><TD style="TEXT-ALIGN: right">14</TD><TD style="TEXT-ALIGN: right">15</TD><TD style="TEXT-ALIGN: right">8</TD><TD style="TEXT-ALIGN: right">9</TD><TD style="TEXT-ALIGN: right">914,015,008,009 </TD><TD style="TEXT-ALIGN: right">10 </TD><TD>Miss Take</TD><TD style="TEXT-ALIGN: right">30-Aug-72</TD><TD>Teacher</TD><TD style="TEXT-ALIGN: right">7</TD></TR><TR style="HEIGHT: 19px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">31</TD><TD>Fixx</TD><TD>Herr</TD><TD>Herr Fixx</TD><TD></TD><TD>Plane</TD><TD>Woody</TD><TD>Woody Plane</TD><TD></TD><TD style="TEXT-ALIGN: right">6</TD><TD style="TEXT-ALIGN: right">5</TD><TD style="TEXT-ALIGN: right">5</TD><TD style="TEXT-ALIGN: right">18</TD><TD style="TEXT-ALIGN: right">14</TD><TD style="TEXT-ALIGN: right">7</TD><TD style="TEXT-ALIGN: right">605,018,014,007 </TD><TD style="TEXT-ALIGN: right">7 </TD><TD>Doctor Who</TD><TD style="TEXT-ALIGN: right">01-Jan-00</TD><TD>Time Lord</TD><TD style="TEXT-ALIGN: right">10</TD></TR><TR style="HEIGHT: 19px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">32</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></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD></TR><TR style="HEIGHT: 19px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">33</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></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD></TR><TR style="HEIGHT: 19px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">34</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></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD></TR></TBODY></TABLE>
<TABLE style="BORDER-BOTTOM-STYLE: groove; BORDER-BOTTOM-COLOR: #00ff00; BACKGROUND-COLOR: #fffcf9; BORDER-TOP-COLOR: #00ff00; BORDER-LEFT-STYLE: groove; FONT-FAMILY: Arial; BORDER-TOP-STYLE: groove; COLOR: #000000; BORDER-RIGHT-COLOR: #00ff00; BORDER-RIGHT-STYLE: groove; FONT-SIZE: 10pt; BORDER-LEFT-COLOR: #00ff00"><TBODY><TR><TD>Spreadsheet Formulas</TD></TR><TR><TD><TABLE style="FONT-FAMILY: Arial; FONT-SIZE: 9pt" border=1 cellSpacing=0 cellPadding=2><TBODY><TR style="BACKGROUND-COLOR: #cacaca; FONT-SIZE: 10pt"><TD>Cell</TD><TD>Formula</TD></TR><TR><TD>S12</TD><TD>=IF(ISERROR(RIGHT(F12,LEN(F12)-FIND("*",SUBSTITUTE(F12," ","*",LEN(F12)-LEN(SUBSTITUTE(F12," ","")))))),"",RIGHT(F12,LEN(F12)-FIND("*",SUBSTITUTE(F12," ","*",LEN(F12)-LEN(SUBSTITUTE(F12," ",""))))))</TD></TR><TR><TD>T12</TD><TD>=IF(ISERROR(LEFT(F12,FIND(" ",F12)-1)),F12,(LEFT(F12,FIND(" ",F12)-1)))</TD></TR><TR><TD>U12</TD><TD>=T12& " "&S12</TD></TR><TR><TD>AA12</TD><TD>=IF(S12="",0,COUNTIF($S$12:$S$35,"<"&S12))</TD></TR><TR><TD>AB12</TD><TD>=IF(T12="",0,COUNTIF($T$12:$T$35,"<"&T12))</TD></TR><TR><TD>AC12</TD><TD>=IF(F12="",0,COUNTIF($F$12:$F$35,"<"&F12))</TD></TR><TR><TD>AD12</TD><TD>=RANK(G12,$G$12:$G$34)+COUNTIF($G$12:G12,G12)-1</TD></TR><TR><TD>AE12</TD><TD>=IF(H12="",0,COUNTIF($H$12:$H$35,"<"&H12))</TD></TR><TR><TD>AF12</TD><TD>=IF(I12="",0,COUNTIF($I$12:$I$35,"<"&I12))</TD></TR><TR><TD>AG12</TD><TD>=AA12*100000000000+AB12*1000000000+AD12*1000000+AE12*1000+AF12</TD></TR><TR><TD>AH12</TD><TD>=COUNT(AG$12:AG$34)-(RANK(AG12,AG$12:AG$34)+COUNTIF(AG$12:AG12,AG12))+2</TD></TR><TR><TD>AI12</TD><TD>=IF(AH12="","",INDEX($F$12:$F$34,MATCH(ROW()-ROW($AH$11),$AH$12:$AH$34,0)))</TD></TR><TR><TD>AJ12</TD><TD>=IF(AI12="","",INDEX($G$12:$G$34,MATCH(ROW()-ROW($AH$11),$AH$12:$AH$34,0)))</TD></TR><TR><TD>AK12</TD><TD>=IF(AH12="","",INDEX($H$12:$H$34,MATCH(ROW()-ROW($AH$11),$AH$12:$AH$34,0)))</TD></TR><TR><TD>AL12</TD><TD>=IF(AH12="","",INDEX($I$12:$I$31,MATCH(ROW()-ROW($AH$11),$AH$12:$AH$34,0)))</TD></TR><TR><TD>S13</TD><TD>=IF(ISERROR(RIGHT(F13,LEN(F13)-FIND("*",SUBSTITUTE(F13," ","*",LEN(F13)-LEN(SUBSTITUTE(F13," ","")))))),"",RIGHT(F13,LEN(F13)-FIND("*",SUBSTITUTE(F13," ","*",LEN(F13)-LEN(SUBSTITUTE(F13," ",""))))))</TD></TR><TR><TD>T13</TD><TD>=IF(ISERROR(LEFT(F13,FIND(" ",F13)-1)),F13,(LEFT(F13,FIND(" ",F13)-1)))</TD></TR><TR><TD>U13</TD><TD>=T13& " "&S13</TD></TR><TR><TD>AA13</TD><TD>=IF(S13="",0,COUNTIF($S$12:$S$35,"<"&S13))</TD></TR><TR><TD>AB13</TD><TD>=IF(T13="",0,COUNTIF($T$12:$T$35,"<"&T13))</TD></TR><TR><TD>AC13</TD><TD>=IF(F13="",0,COUNTIF($F$12:$F$35,"<"&F13))</TD></TR><TR><TD>AD13</TD><TD>=RANK(G13,$G$12:$G$34)+COUNTIF($G$12:G13,G13)-1</TD></TR><TR><TD>AE13</TD><TD>=IF(H13="",0,COUNTIF($H$12:$H$35,"<"&H13))</TD></TR><TR><TD>AF13</TD><TD>=IF(I13="",0,COUNTIF($I$12:$I$35,"<"&I13))</TD></TR><TR><TD>AG13</TD><TD>=AA13*100000000000+AB13*1000000000+AD13*1000000+AE13*1000+AF13</TD></TR><TR><TD>AH13</TD><TD>=COUNT(AG$12:AG$34)-(RANK(AG13,AG$12:AG$34)+COUNTIF(AG$12:AG13,AG13))+2</TD></TR><TR><TD>AI13</TD><TD>=IF(AH13="","",INDEX($F$12:$F$34,MATCH(ROW()-ROW($AH$11),$AH$12:$AH$34,0)))</TD></TR><TR><TD>AJ13</TD><TD>=IF(AI13="","",INDEX($G$12:$G$34,MATCH(ROW()-ROW($AH$11),$AH$12:$AH$34,0)))</TD></TR><TR><TD>AK13</TD><TD>=IF(AH13="","",INDEX($H$12:$H$34,MATCH(ROW()-ROW($AH$11),$AH$12:$AH$34,0)))</TD></TR><TR><TD>AL13</TD><TD>=IF(AH13="","",INDEX($I$12:$I$31,MATCH(ROW()-ROW($AH$11),$AH$12:$AH$34,0)))</TD></TR><TR><TD>S14</TD><TD>=IF(ISERROR(RIGHT(F14,LEN(F14)-FIND("*",SUBSTITUTE(F14," ","*",LEN(F14)-LEN(SUBSTITUTE(F14," ","")))))),"",RIGHT(F14,LEN(F14)-FIND("*",SUBSTITUTE(F14," ","*",LEN(F14)-LEN(SUBSTITUTE(F14," ",""))))))</TD></TR><TR><TD>T14</TD><TD>=IF(ISERROR(LEFT(F14,FIND(" ",F14)-1)),F14,(LEFT(F14,FIND(" ",F14)-1)))</TD></TR><TR><TD>U14</TD><TD>=T14& " "&S14</TD></TR><TR><TD>AA14</TD><TD>=IF(S14="",0,COUNTIF($S$12:$S$35,"<"&S14))</TD></TR><TR><TD>AB14</TD><TD>=IF(T14="",0,COUNTIF($T$12:$T$35,"<"&T14))</TD></TR><TR><TD>AC14</TD><TD>=IF(F14="",0,COUNTIF($F$12:$F$35,"<"&F14))</TD></TR><TR><TD>AD14</TD><TD>=RANK(G14,$G$12:$G$34)+COUNTIF($G$12:G14,G14)-1</TD></TR><TR><TD>AE14</TD><TD>=IF(H14="",0,COUNTIF($H$12:$H$35,"<"&H14))</TD></TR><TR><TD>AF14</TD><TD>=IF(I14="",0,COUNTIF($I$12:$I$35,"<"&I14))</TD></TR><TR><TD>AG14</TD><TD>=AA14*100000000000+AB14*1000000000+AD14*1000000+AE14*1000+AF14</TD></TR><TR><TD>AH14</TD><TD>=COUNT(AG$12:AG$34)-(RANK(AG14,AG$12:AG$34)+COUNTIF(AG$12:AG14,AG14))+2</TD></TR><TR><TD>AI14</TD><TD>=IF(AH14="","",INDEX($F$12:$F$34,MATCH(ROW()-ROW($AH$11),$AH$12:$AH$34,0)))</TD></TR><TR><TD>AJ14</TD><TD>=IF(AI14="","",INDEX($G$12:$G$34,MATCH(ROW()-ROW($AH$11),$AH$12:$AH$34,0)))</TD></TR><TR><TD>AK14</TD><TD>=IF(AH14="","",INDEX($H$12:$H$34,MATCH(ROW()-ROW($AH$11),$AH$12:$AH$34,0)))</TD></TR><TR><TD>AL14</TD><TD>=IF(AH14="","",INDEX($I$12:$I$31,MATCH(ROW()-ROW($AH$11),$AH$12:$AH$34,0)))</TD></TR><TR><TD>S15</TD><TD>=IF(ISERROR(RIGHT(F15,LEN(F15)-FIND("*",SUBSTITUTE(F15," ","*",LEN(F15)-LEN(SUBSTITUTE(F15," ","")))))),"",RIGHT(F15,LEN(F15)-FIND("*",SUBSTITUTE(F15," ","*",LEN(F15)-LEN(SUBSTITUTE(F15," ",""))))))</TD></TR><TR><TD>T15</TD><TD>=IF(ISERROR(LEFT(F15,FIND(" ",F15)-1)),F15,(LEFT(F15,FIND(" ",F15)-1)))</TD></TR><TR><TD>U15</TD><TD>=T15& " "&S15</TD></TR><TR><TD>AA15</TD><TD>=IF(S15="",0,COUNTIF($S$12:$S$35,"<"&S15))</TD></TR><TR><TD>AB15</TD><TD>=IF(T15="",0,COUNTIF($T$12:$T$35,"<"&T15))</TD></TR><TR><TD>AC15</TD><TD>=IF(F15="",0,COUNTIF($F$12:$F$35,"<"&F15))</TD></TR><TR><TD>AD15</TD><TD>=RANK(G15,$G$12:$G$34)+COUNTIF($G$12:G15,G15)-1</TD></TR><TR><TD>AE15</TD><TD>=IF(H15="",0,COUNTIF($H$12:$H$35,"<"&H15))</TD></TR><TR><TD>AF15</TD><TD>=IF(I15="",0,COUNTIF($I$12:$I$35,"<"&I15))</TD></TR><TR><TD>AG15</TD><TD>=AA15*100000000000+AB15*1000000000+AD15*1000000+AE15*1000+AF15</TD></TR><TR><TD>AH15</TD><TD>=COUNT(AG$12:AG$34)-(RANK(AG15,AG$12:AG$34)+COUNTIF(AG$12:AG15,AG15))+2</TD></TR><TR><TD>AI15</TD><TD>=IF(AH15="","",INDEX($F$12:$F$34,MATCH(ROW()-ROW($AH$11),$AH$12:$AH$34,0)))</TD></TR><TR><TD>AJ15</TD><TD>=IF(AI15="","",INDEX($G$12:$G$34,MATCH(ROW()-ROW($AH$11),$AH$12:$AH$34,0)))</TD></TR><TR><TD>AK15</TD><TD>=IF(AH15="","",INDEX($H$12:$H$34,MATCH(ROW()-ROW($AH$11),$AH$12:$AH$34,0)))</TD></TR><TR><TD>AL15</TD><TD>=IF(AH15="","",INDEX($I$12:$I$31,MATCH(ROW()-ROW($AH$11),$AH$12:$AH$34,0)))</TD></TR><TR><TD>S16</TD><TD>=IF(ISERROR(RIGHT(F16,LEN(F16)-FIND("*",SUBSTITUTE(F16," ","*",LEN(F16)-LEN(SUBSTITUTE(F16," ","")))))),"",RIGHT(F16,LEN(F16)-FIND("*",SUBSTITUTE(F16," ","*",LEN(F16)-LEN(SUBSTITUTE(F16," ",""))))))</TD></TR><TR><TD>T16</TD><TD>=IF(ISERROR(LEFT(F16,FIND(" ",F16)-1)),F16,(LEFT(F16,FIND(" ",F16)-1)))</TD></TR><TR><TD>U16</TD><TD>=T16& " "&S16</TD></TR><TR><TD>AA16</TD><TD>=IF(S16="",0,COUNTIF($S$12:$S$35,"<"&S16))</TD></TR><TR><TD>AB16</TD><TD>=IF(T16="",0,COUNTIF($T$12:$T$35,"<"&T16))</TD></TR><TR><TD>AC16</TD><TD>=IF(F16="",0,COUNTIF($F$12:$F$35,"<"&F16))</TD></TR><TR><TD>AD16</TD><TD>=RANK(G16,$G$12:$G$34)+COUNTIF($G$12:G16,G16)-1</TD></TR><TR><TD>AE16</TD><TD>=IF(H16="",0,COUNTIF($H$12:$H$35,"<"&H16))</TD></TR><TR><TD>AF16</TD><TD>=IF(I16="",0,COUNTIF($I$12:$I$35,"<"&I16))</TD></TR><TR><TD>AG16</TD><TD>=AA16*100000000000+AB16*1000000000+AD16*1000000+AE16*1000+AF16</TD></TR><TR><TD>AH16</TD><TD>=COUNT(AG$12:AG$34)-(RANK(AG16,AG$12:AG$34)+COUNTIF(AG$12:AG16,AG16))+2</TD></TR><TR><TD>AI16</TD><TD>=IF(AH16="","",INDEX($F$12:$F$34,MATCH(ROW()-ROW($AH$11),$AH$12:$AH$34,0)))</TD></TR><TR><TD>AJ16</TD><TD>=IF(AI16="","",INDEX($G$12:$G$34,MATCH(ROW()-ROW($AH$11),$AH$12:$AH$34,0)))</TD></TR><TR><TD>AK16</TD><TD>=IF(AH16="","",INDEX($H$12:$H$34,MATCH(ROW()-ROW($AH$11),$AH$12:$AH$34,0)))</TD></TR><TR><TD>AL16</TD><TD>=IF(AH16="","",INDEX($I$12:$I$31,MATCH(ROW()-ROW($AH$11),$AH$12:$AH$34,0)))</TD></TR><TR><TD>S17</TD><TD>=IF(ISERROR(RIGHT(F17,LEN(F17)-FIND("*",SUBSTITUTE(F17," ","*",LEN(F17)-LEN(SUBSTITUTE(F17," ","")))))),"",RIGHT(F17,LEN(F17)-FIND("*",SUBSTITUTE(F17," ","*",LEN(F17)-LEN(SUBSTITUTE(F17," ",""))))))</TD></TR><TR><TD>T17</TD><TD>=IF(ISERROR(LEFT(F17,FIND(" ",F17)-1)),F17,(LEFT(F17,FIND(" ",F17)-1)))</TD></TR><TR><TD>U17</TD><TD>=T17& " "&S17</TD></TR><TR><TD>AA17</TD><TD>=IF(S17="",0,COUNTIF($S$12:$S$35,"<"&S17))</TD></TR><TR><TD>AB17</TD><TD>=IF(T17="",0,COUNTIF($T$12:$T$35,"<"&T17))</TD></TR><TR><TD>AC17</TD><TD>=IF(F17="",0,COUNTIF($F$12:$F$35,"<"&F17))</TD></TR><TR><TD>AD17</TD><TD>=RANK(G17,$G$12:$G$34)+COUNTIF($G$12:G17,G17)-1</TD></TR><TR><TD>AE17</TD><TD>=IF(H17="",0,COUNTIF($H$12:$H$35,"<"&H17))</TD></TR><TR><TD>AF17</TD><TD>=IF(I17="",0,COUNTIF($I$12:$I$35,"<"&I17))</TD></TR><TR><TD>AG17</TD><TD>=AA17*100000000000+AB17*1000000000+AD17*1000000+AE17*1000+AF17</TD></TR><TR><TD>AH17</TD><TD>=COUNT(AG$12:AG$34)-(RANK(AG17,AG$12:AG$34)+COUNTIF(AG$12:AG17,AG17))+2</TD></TR><TR><TD>AI17</TD><TD>=IF(AH17="","",INDEX($F$12:$F$34,MATCH(ROW()-ROW($AH$11),$AH$12:$AH$34,0)))</TD></TR><TR><TD>AJ17</TD><TD>=IF(AI17="","",INDEX($G$12:$G$34,MATCH(ROW()-ROW($AH$11),$AH$12:$AH$34,0)))</TD></TR><TR><TD>AK17</TD><TD>=IF(AH17="","",INDEX($H$12:$H$34,MATCH(ROW()-ROW($AH$11),$AH$12:$AH$34,0)))</TD></TR><TR><TD>AL17</TD><TD>=IF(AH17="","",INDEX($I$12:$I$31,MATCH(ROW()-ROW($AH$11),$AH$12:$AH$34,0)))</TD></TR><TR><TD>S18</TD><TD>=IF(ISERROR(RIGHT(F18,LEN(F18)-FIND("*",SUBSTITUTE(F18," ","*",LEN(F18)-LEN(SUBSTITUTE(F18," ","")))))),"",RIGHT(F18,LEN(F18)-FIND("*",SUBSTITUTE(F18," ","*",LEN(F18)-LEN(SUBSTITUTE(F18," ",""))))))</TD></TR><TR><TD>T18</TD><TD>=IF(ISERROR(LEFT(F18,FIND(" ",F18)-1)),F18,(LEFT(F18,FIND(" ",F18)-1)))</TD></TR><TR><TD>U18</TD><TD>=T18& " "&S18</TD></TR><TR><TD>AA18</TD><TD>=IF(S18="",0,COUNTIF($S$12:$S$35,"<"&S18))</TD></TR><TR><TD>AB18</TD><TD>=IF(T18="",0,COUNTIF($T$12:$T$35,"<"&T18))</TD></TR><TR><TD>AC18</TD><TD>=IF(F18="",0,COUNTIF($F$12:$F$35,"<"&F18))</TD></TR><TR><TD>AD18</TD><TD>=RANK(G18,$G$12:$G$34)+COUNTIF($G$12:G18,G18)-1</TD></TR><TR><TD>AE18</TD><TD>=IF(H18="",0,COUNTIF($H$12:$H$35,"<"&H18))</TD></TR><TR><TD>AF18</TD><TD>=IF(I18="",0,COUNTIF($I$12:$I$35,"<"&I18))</TD></TR><TR><TD>AG18</TD><TD>=AA18*100000000000+AB18*1000000000+AD18*1000000+AE18*1000+AF18</TD></TR><TR><TD>AH18</TD><TD>=COUNT(AG$12:AG$34)-(RANK(AG18,AG$12:AG$34)+COUNTIF(AG$12:AG18,AG18))+2</TD></TR><TR><TD>AI18</TD><TD>=IF(AH18="","",INDEX($F$12:$F$34,MATCH(ROW()-ROW($AH$11),$AH$12:$AH$34,0)))</TD></TR><TR><TD>AJ18</TD><TD>=IF(AI18="","",INDEX($G$12:$G$34,MATCH(ROW()-ROW($AH$11),$AH$12:$AH$34,0)))</TD></TR><TR><TD>AK18</TD><TD>=IF(AH18="","",INDEX($H$12:$H$34,MATCH(ROW()-ROW($AH$11),$AH$12:$AH$34,0)))</TD></TR><TR><TD>AL18</TD><TD>=IF(AH18="","",INDEX($I$12:$I$31,MATCH(ROW()-ROW($AH$11),$AH$12:$AH$34,0)))</TD></TR><TR><TD>S19</TD><TD>=IF(ISERROR(RIGHT(F19,LEN(F19)-FIND("*",SUBSTITUTE(F19," ","*",LEN(F19)-LEN(SUBSTITUTE(F19," ","")))))),"",RIGHT(F19,LEN(F19)-FIND("*",SUBSTITUTE(F19," ","*",LEN(F19)-LEN(SUBSTITUTE(F19," ",""))))))</TD></TR><TR><TD>T19</TD><TD>=IF(ISERROR(LEFT(F19,FIND(" ",F19)-1)),F19,(LEFT(F19,FIND(" ",F19)-1)))</TD></TR><TR><TD>U19</TD><TD>=T19& " "&S19</TD></TR><TR><TD>AA19</TD><TD>=IF(S19="",0,COUNTIF($S$12:$S$35,"<"&S19))</TD></TR><TR><TD>AB19</TD><TD>=IF(T19="",0,COUNTIF($T$12:$T$35,"<"&T19))</TD></TR><TR><TD>AC19</TD><TD>=IF(F19="",0,COUNTIF($F$12:$F$35,"<"&F19))</TD></TR><TR><TD>AD19</TD><TD>=RANK(G19,$G$12:$G$34)+COUNTIF($G$12:G19,G19)-1</TD></TR><TR><TD>AE19</TD><TD>=IF(H19="",0,COUNTIF($H$12:$H$35,"<"&H19))</TD></TR><TR><TD>AF19</TD><TD>=IF(I19="",0,COUNTIF($I$12:$I$35,"<"&I19))</TD></TR><TR><TD>AG19</TD><TD>=AA19*100000000000+AB19*1000000000+AD19*1000000+AE19*1000+AF19</TD></TR><TR><TD>AH19</TD><TD>=COUNT(AG$12:AG$34)-(RANK(AG19,AG$12:AG$34)+COUNTIF(AG$12:AG19,AG19))+2</TD></TR><TR><TD>AI19</TD><TD>=IF(AH19="","",INDEX($F$12:$F$34,MATCH(ROW()-ROW($AH$11),$AH$12:$AH$34,0)))</TD></TR><TR><TD>AJ19</TD><TD>=IF(AI19="","",INDEX($G$12:$G$34,MATCH(ROW()-ROW($AH$11),$AH$12:$AH$34,0)))</TD></TR><TR><TD>AK19</TD><TD>=IF(AH19="","",INDEX($H$12:$H$34,MATCH(ROW()-ROW($AH$11),$AH$12:$AH$34,0)))</TD></TR><TR><TD>AL19</TD><TD>=IF(AH19="","",INDEX($I$12:$I$31,MATCH(ROW()-ROW($AH$11),$AH$12:$AH$34,0)))</TD></TR><TR><TD>S20</TD><TD>=IF(ISERROR(RIGHT(F20,LEN(F20)-FIND("*",SUBSTITUTE(F20," ","*",LEN(F20)-LEN(SUBSTITUTE(F20," ","")))))),"",RIGHT(F20,LEN(F20)-FIND("*",SUBSTITUTE(F20," ","*",LEN(F20)-LEN(SUBSTITUTE(F20," ",""))))))</TD></TR><TR><TD>T20</TD><TD>=IF(ISERROR(LEFT(F20,FIND(" ",F20)-1)),F20,(LEFT(F20,FIND(" ",F20)-1)))</TD></TR><TR><TD>U20</TD><TD>=T20& " "&S20</TD></TR><TR><TD>AA20</TD><TD>=IF(S20="",0,COUNTIF($S$12:$S$35,"<"&S20))</TD></TR><TR><TD>AB20</TD><TD>=IF(T20="",0,COUNTIF($T$12:$T$35,"<"&T20))</TD></TR><TR><TD>AC20</TD><TD>=IF(F20="",0,COUNTIF($F$12:$F$35,"<"&F20))</TD></TR><TR><TD>AD20</TD><TD>=RANK(G20,$G$12:$G$34)+COUNTIF($G$12:G20,G20)-1</TD></TR><TR><TD>AE20</TD><TD>=IF(H20="",0,COUNTIF($H$12:$H$35,"<"&H20))</TD></TR><TR><TD>AF20</TD><TD>=IF(I20="",0,COUNTIF($I$12:$I$35,"<"&I20))</TD></TR><TR><TD>AG20</TD><TD>=AA20*100000000000+AB20*1000000000+AD20*1000000+AE20*1000+AF20</TD></TR><TR><TD>AH20</TD><TD>=COUNT(AG$12:AG$34)-(RANK(AG20,AG$12:AG$34)+COUNTIF(AG$12:AG20,AG20))+2</TD></TR><TR><TD>AI20</TD><TD>=IF(AH20="","",INDEX($F$12:$F$34,MATCH(ROW()-ROW($AH$11),$AH$12:$AH$34,0)))</TD></TR><TR><TD>AJ20</TD><TD>=IF(AI20="","",INDEX($G$12:$G$34,MATCH(ROW()-ROW($AH$11),$AH$12:$AH$34,0)))</TD></TR><TR><TD>AK20</TD><TD>=IF(AH20="","",INDEX($H$12:$H$34,MATCH(ROW()-ROW($AH$11),$AH$12:$AH$34,0)))</TD></TR><TR><TD>AL20</TD><TD>=IF(AH20="","",INDEX($I$12:$I$31,MATCH(ROW()-ROW($AH$11),$AH$12:$AH$34,0)))</TD></TR><TR><TD>S21</TD><TD>=IF(ISERROR(RIGHT(F21,LEN(F21)-FIND("*",SUBSTITUTE(F21," ","*",LEN(F21)-LEN(SUBSTITUTE(F21," ","")))))),"",RIGHT(F21,LEN(F21)-FIND("*",SUBSTITUTE(F21," ","*",LEN(F21)-LEN(SUBSTITUTE(F21," ",""))))))</TD></TR><TR><TD>T21</TD><TD>=IF(ISERROR(LEFT(F21,FIND(" ",F21)-1)),F21,(LEFT(F21,FIND(" ",F21)-1)))</TD></TR><TR><TD>U21</TD><TD>=T21& " "&S21</TD></TR><TR><TD>AA21</TD><TD>=IF(S21="",0,COUNTIF($S$12:$S$35,"<"&S21))</TD></TR><TR><TD>AB21</TD><TD>=IF(T21="",0,COUNTIF($T$12:$T$35,"<"&T21))</TD></TR><TR><TD>AC21</TD><TD>=IF(F21="",0,COUNTIF($F$12:$F$35,"<"&F21))</TD></TR><TR><TD>AD21</TD><TD>=RANK(G21,$G$12:$G$34)+COUNTIF($G$12:G21,G21)-1</TD></TR><TR><TD>AE21</TD><TD>=IF(H21="",0,COUNTIF($H$12:$H$35,"<"&H21))</TD></TR><TR><TD>AF21</TD><TD>=IF(I21="",0,COUNTIF($I$12:$I$35,"<"&I21))</TD></TR><TR><TD>AG21</TD><TD>=AA21*100000000000+AB21*1000000000+AD21*1000000+AE21*1000+AF21</TD></TR><TR><TD>AH21</TD><TD>=COUNT(AG$12:AG$34)-(RANK(AG21,AG$12:AG$34)+COUNTIF(AG$12:AG21,AG21))+2</TD></TR><TR><TD>AI21</TD><TD>=IF(AH21="","",INDEX($F$12:$F$34,MATCH(ROW()-ROW($AH$11),$AH$12:$AH$34,0)))</TD></TR><TR><TD>AJ21</TD><TD>=IF(AI21="","",INDEX($G$12:$G$34,MATCH(ROW()-ROW($AH$11),$AH$12:$AH$34,0)))</TD></TR><TR><TD>AK21</TD><TD>=IF(AH21="","",INDEX($H$12:$H$34,MATCH(ROW()-ROW($AH$11),$AH$12:$AH$34,0)))</TD></TR><TR><TD>AL21</TD><TD>=IF(AH21="","",INDEX($I$12:$I$31,MATCH(ROW()-ROW($AH$11),$AH$12:$AH$34,0)))</TD></TR><TR><TD>S22</TD><TD>=IF(ISERROR(RIGHT(F22,LEN(F22)-FIND("*",SUBSTITUTE(F22," ","*",LEN(F22)-LEN(SUBSTITUTE(F22," ","")))))),"",RIGHT(F22,LEN(F22)-FIND("*",SUBSTITUTE(F22," ","*",LEN(F22)-LEN(SUBSTITUTE(F22," ",""))))))</TD></TR><TR><TD>T22</TD><TD>=IF(ISERROR(LEFT(F22,FIND(" ",F22)-1)),F22,(LEFT(F22,FIND(" ",F22)-1)))</TD></TR><TR><TD>U22</TD><TD>=T22& " "&S22</TD></TR><TR><TD>AA22</TD><TD>=IF(S22="",0,COUNTIF($S$12:$S$35,"<"&S22))</TD></TR><TR><TD>AB22</TD><TD>=IF(T22="",0,COUNTIF($T$12:$T$35,"<"&T22))</TD></TR><TR><TD>AC22</TD><TD>=IF(F22="",0,COUNTIF($F$12:$F$35,"<"&F22))</TD></TR><TR><TD>AD22</TD><TD>=RANK(G22,$G$12:$G$34)+COUNTIF($G$12:G22,G22)-1</TD></TR><TR><TD>AE22</TD><TD>=IF(H22="",0,COUNTIF($H$12:$H$35,"<"&H22))</TD></TR><TR><TD>AF22</TD><TD>=IF(I22="",0,COUNTIF($I$12:$I$35,"<"&I22))</TD></TR><TR><TD>AG22</TD><TD>=AA22*100000000000+AB22*1000000000+AD22*1000000+AE22*1000+AF22</TD></TR><TR><TD>AH22</TD><TD>=COUNT(AG$12:AG$34)-(RANK(AG22,AG$12:AG$34)+COUNTIF(AG$12:AG22,AG22))+2</TD></TR><TR><TD>AI22</TD><TD>=IF(AH22="","",INDEX($F$12:$F$34,MATCH(ROW()-ROW($AH$11),$AH$12:$AH$34,0)))</TD></TR><TR><TD>AJ22</TD><TD>=IF(AI22="","",INDEX($G$12:$G$34,MATCH(ROW()-ROW($AH$11),$AH$12:$AH$34,0)))</TD></TR><TR><TD>AK22</TD><TD>=IF(AH22="","",INDEX($H$12:$H$34,MATCH(ROW()-ROW($AH$11),$AH$12:$AH$34,0)))</TD></TR><TR><TD>AL22</TD><TD>=IF(AH22="","",INDEX($I$12:$I$31,MATCH(ROW()-ROW($AH$11),$AH$12:$AH$34,0)))</TD></TR><TR><TD>S23</TD><TD>=IF(ISERROR(RIGHT(F23,LEN(F23)-FIND("*",SUBSTITUTE(F23," ","*",LEN(F23)-LEN(SUBSTITUTE(F23," ","")))))),"",RIGHT(F23,LEN(F23)-FIND("*",SUBSTITUTE(F23," ","*",LEN(F23)-LEN(SUBSTITUTE(F23," ",""))))))</TD></TR><TR><TD>T23</TD><TD>=IF(ISERROR(LEFT(F23,FIND(" ",F23)-1)),F23,(LEFT(F23,FIND(" ",F23)-1)))</TD></TR><TR><TD>U23</TD><TD>=T23& " "&S23</TD></TR><TR><TD>AA23</TD><TD>=IF(S23="",0,COUNTIF($S$12:$S$35,"<"&S23))</TD></TR><TR><TD>AB23</TD><TD>=IF(T23="",0,COUNTIF($T$12:$T$35,"<"&T23))</TD></TR><TR><TD>AC23</TD><TD>=IF(F23="",0,COUNTIF($F$12:$F$35,"<"&F23))</TD></TR><TR><TD>AD23</TD><TD>=RANK(G23,$G$12:$G$34)+COUNTIF($G$12:G23,G23)-1</TD></TR><TR><TD>AE23</TD><TD>=IF(H23="",0,COUNTIF($H$12:$H$35,"<"&H23))</TD></TR><TR><TD>AF23</TD><TD>=IF(I23="",0,COUNTIF($I$12:$I$35,"<"&I23))</TD></TR><TR><TD>AG23</TD><TD>=AA23*100000000000+AB23*1000000000+AD23*1000000+AE23*1000+AF23</TD></TR><TR><TD>AH23</TD><TD>=COUNT(AG$12:AG$34)-(RANK(AG23,AG$12:AG$34)+COUNTIF(AG$12:AG23,AG23))+2</TD></TR><TR><TD>AI23</TD><TD>=IF(AH23="","",INDEX($F$12:$F$34,MATCH(ROW()-ROW($AH$11),$AH$12:$AH$34,0)))</TD></TR><TR><TD>AJ23</TD><TD>=IF(AI23="","",INDEX($G$12:$G$34,MATCH(ROW()-ROW($AH$11),$AH$12:$AH$34,0)))</TD></TR><TR><TD>AK23</TD><TD>=IF(AH23="","",INDEX($H$12:$H$34,MATCH(ROW()-ROW($AH$11),$AH$12:$AH$34,0)))</TD></TR><TR><TD>AL23</TD><TD>=IF(AH23="","",INDEX($I$12:$I$31,MATCH(ROW()-ROW($AH$11),$AH$12:$AH$34,0)))</TD></TR><TR><TD>S24</TD><TD>=IF(ISERROR(RIGHT(F24,LEN(F24)-FIND("*",SUBSTITUTE(F24," ","*",LEN(F24)-LEN(SUBSTITUTE(F24," ","")))))),"",RIGHT(F24,LEN(F24)-FIND("*",SUBSTITUTE(F24," ","*",LEN(F24)-LEN(SUBSTITUTE(F24," ",""))))))</TD></TR><TR><TD>T24</TD><TD>=IF(ISERROR(LEFT(F24,FIND(" ",F24)-1)),F24,(LEFT(F24,FIND(" ",F24)-1)))</TD></TR><TR><TD>U24</TD><TD>=T24& " "&S24</TD></TR><TR><TD>AA24</TD><TD>=IF(S24="",0,COUNTIF($S$12:$S$35,"<"&S24))</TD></TR><TR><TD>AB24</TD><TD>=IF(T24="",0,COUNTIF($T$12:$T$35,"<"&T24))</TD></TR><TR><TD>AC24</TD><TD>=IF(F24="",0,COUNTIF($F$12:$F$35,"<"&F24))</TD></TR><TR><TD>AD24</TD><TD>=RANK(G24,$G$12:$G$34)+COUNTIF($G$12:G24,G24)-1</TD></TR><TR><TD>AE24</TD><TD>=IF(H24="",0,COUNTIF($H$12:$H$35,"<"&H24))</TD></TR><TR><TD>AF24</TD><TD>=IF(I24="",0,COUNTIF($I$12:$I$35,"<"&I24))</TD></TR><TR><TD>AG24</TD><TD>=AA24*100000000000+AB24*1000000000+AD24*1000000+AE24*1000+AF24</TD></TR><TR><TD>AH24</TD><TD>=COUNT(AG$12:AG$34)-(RANK(AG24,AG$12:AG$34)+COUNTIF(AG$12:AG24,AG24))+2</TD></TR><TR><TD>AI24</TD><TD>=IF(AH24="","",INDEX($F$12:$F$34,MATCH(ROW()-ROW($AH$11),$AH$12:$AH$34,0)))</TD></TR><TR><TD>AJ24</TD><TD>=IF(AI24="","",INDEX($G$12:$G$34,MATCH(ROW()-ROW($AH$11),$AH$12:$AH$34,0)))</TD></TR><TR><TD>AK24</TD><TD>=IF(AH24="","",INDEX($H$12:$H$34,MATCH(ROW()-ROW($AH$11),$AH$12:$AH$34,0)))</TD></TR><TR><TD>AL24</TD><TD>=IF(AH24="","",INDEX($I$12:$I$31,MATCH(ROW()-ROW($AH$11),$AH$12:$AH$34,0)))</TD></TR><TR><TD>S25</TD><TD>=IF(ISERROR(RIGHT(F25,LEN(F25)-FIND("*",SUBSTITUTE(F25," ","*",LEN(F25)-LEN(SUBSTITUTE(F25," ","")))))),"",RIGHT(F25,LEN(F25)-FIND("*",SUBSTITUTE(F25," ","*",LEN(F25)-LEN(SUBSTITUTE(F25," ",""))))))</TD></TR><TR><TD>T25</TD><TD>=IF(ISERROR(LEFT(F25,FIND(" ",F25)-1)),F25,(LEFT(F25,FIND(" ",F25)-1)))</TD></TR><TR><TD>U25</TD><TD>=T25& " "&S25</TD></TR><TR><TD>AA25</TD><TD>=IF(S25="",0,COUNTIF($S$12:$S$35,"<"&S25))</TD></TR><TR><TD>AB25</TD><TD>=IF(T25="",0,COUNTIF($T$12:$T$35,"<"&T25))</TD></TR><TR><TD>AC25</TD><TD>=IF(F25="",0,COUNTIF($F$12:$F$35,"<"&F25))</TD></TR><TR><TD>AD25</TD><TD>=RANK(G25,$G$12:$G$34)+COUNTIF($G$12:G25,G25)-1</TD></TR><TR><TD>AE25</TD><TD>=IF(H25="",0,COUNTIF($H$12:$H$35,"<"&H25))</TD></TR><TR><TD>AF25</TD><TD>=IF(I25="",0,COUNTIF($I$12:$I$35,"<"&I25))</TD></TR><TR><TD>AG25</TD><TD>=AA25*100000000000+AB25*1000000000+AD25*1000000+AE25*1000+AF25</TD></TR><TR><TD>AH25</TD><TD>=COUNT(AG$12:AG$34)-(RANK(AG25,AG$12:AG$34)+COUNTIF(AG$12:AG25,AG25))+2</TD></TR><TR><TD>AI25</TD><TD>=IF(AH25="","",INDEX($F$12:$F$34,MATCH(ROW()-ROW($AH$11),$AH$12:$AH$34,0)))</TD></TR><TR><TD>AJ25</TD><TD>=IF(AI25="","",INDEX($G$12:$G$34,MATCH(ROW()-ROW($AH$11),$AH$12:$AH$34,0)))</TD></TR><TR><TD>AK25</TD><TD>=IF(AH25="","",INDEX($H$12:$H$34,MATCH(ROW()-ROW($AH$11),$AH$12:$AH$34,0)))</TD></TR><TR><TD>AL25</TD><TD>=IF(AH25="","",INDEX($I$12:$I$31,MATCH(ROW()-ROW($AH$11),$AH$12:$AH$34,0)))</TD></TR><TR><TD>S26</TD><TD>=IF(ISERROR(RIGHT(F26,LEN(F26)-FIND("*",SUBSTITUTE(F26," ","*",LEN(F26)-LEN(SUBSTITUTE(F26," ","")))))),"",RIGHT(F26,LEN(F26)-FIND("*",SUBSTITUTE(F26," ","*",LEN(F26)-LEN(SUBSTITUTE(F26," ",""))))))</TD></TR><TR><TD>T26</TD><TD>=IF(ISERROR(LEFT(F26,FIND(" ",F26)-1)),F26,(LEFT(F26,FIND(" ",F26)-1)))</TD></TR><TR><TD>U26</TD><TD>=T26& " "&S26</TD></TR><TR><TD>AA26</TD><TD>=IF(S26="",0,COUNTIF($S$12:$S$35,"<"&S26))</TD></TR><TR><TD>AB26</TD><TD>=IF(T26="",0,COUNTIF($T$12:$T$35,"<"&T26))</TD></TR><TR><TD>AC26</TD><TD>=IF(F26="",0,COUNTIF($F$12:$F$35,"<"&F26))</TD></TR><TR><TD>AD26</TD><TD>=RANK(G26,$G$12:$G$34)+COUNTIF($G$12:G26,G26)-1</TD></TR><TR><TD>AE26</TD><TD>=IF(H26="",0,COUNTIF($H$12:$H$35,"<"&H26))</TD></TR><TR><TD>AF26</TD><TD>=IF(I26="",0,COUNTIF($I$12:$I$35,"<"&I26))</TD></TR><TR><TD>AG26</TD><TD>=AA26*100000000000+AB26*1000000000+AD26*1000000+AE26*1000+AF26</TD></TR><TR><TD>AH26</TD><TD>=COUNT(AG$12:AG$34)-(RANK(AG26,AG$12:AG$34)+COUNTIF(AG$12:AG26,AG26))+2</TD></TR><TR><TD>AI26</TD><TD>=IF(AH26="","",INDEX($F$12:$F$34,MATCH(ROW()-ROW($AH$11),$AH$12:$AH$34,0)))</TD></TR><TR><TD>AJ26</TD><TD>=IF(AI26="","",INDEX($G$12:$G$34,MATCH(ROW()-ROW($AH$11),$AH$12:$AH$34,0)))</TD></TR><TR><TD>AK26</TD><TD>=IF(AH26="","",INDEX($H$12:$H$34,MATCH(ROW()-ROW($AH$11),$AH$12:$AH$34,0)))</TD></TR><TR><TD>AL26</TD><TD>=IF(AH26="","",INDEX($I$12:$I$31,MATCH(ROW()-ROW($AH$11),$AH$12:$AH$34,0)))</TD></TR><TR><TD>S27</TD><TD>=IF(ISERROR(RIGHT(F27,LEN(F27)-FIND("*",SUBSTITUTE(F27," ","*",LEN(F27)-LEN(SUBSTITUTE(F27," ","")))))),"",RIGHT(F27,LEN(F27)-FIND("*",SUBSTITUTE(F27," ","*",LEN(F27)-LEN(SUBSTITUTE(F27," ",""))))))</TD></TR><TR><TD>T27</TD><TD>=IF(ISERROR(LEFT(F27,FIND(" ",F27)-1)),F27,(LEFT(F27,FIND(" ",F27)-1)))</TD></TR><TR><TD>U27</TD><TD>=T27& " "&S27</TD></TR><TR><TD>AA27</TD><TD>=IF(S27="",0,COUNTIF($S$12:$S$35,"<"&S27))</TD></TR><TR><TD>AB27</TD><TD>=IF(T27="",0,COUNTIF($T$12:$T$35,"<"&T27))</TD></TR><TR><TD>AC27</TD><TD>=IF(F27="",0,COUNTIF($F$12:$F$35,"<"&F27))</TD></TR><TR><TD>AD27</TD><TD>=RANK(G27,$G$12:$G$34)+COUNTIF($G$12:G27,G27)-1</TD></TR><TR><TD>AE27</TD><TD>=IF(H27="",0,COUNTIF($H$12:$H$35,"<"&H27))</TD></TR><TR><TD>AF27</TD><TD>=IF(I27="",0,COUNTIF($I$12:$I$35,"<"&I27))</TD></TR><TR><TD>AG27</TD><TD>=AA27*100000000000+AB27*1000000000+AD27*1000000+AE27*1000+AF27</TD></TR><TR><TD>AH27</TD><TD>=COUNT(AG$12:AG$34)-(RANK(AG27,AG$12:AG$34)+COUNTIF(AG$12:AG27,AG27))+2</TD></TR><TR><TD>AI27</TD><TD>=IF(AH27="","",INDEX($F$12:$F$34,MATCH(ROW()-ROW($AH$11),$AH$12:$AH$34,0)))</TD></TR><TR><TD>AJ27</TD><TD>=IF(AI27="","",INDEX($G$12:$G$34,MATCH(ROW()-ROW($AH$11),$AH$12:$AH$34,0)))</TD></TR><TR><TD>AK27</TD><TD>=IF(AH27="","",INDEX($H$12:$H$34,MATCH(ROW()-ROW($AH$11),$AH$12:$AH$34,0)))</TD></TR><TR><TD>AL27</TD><TD>=IF(AH27="","",INDEX($I$12:$I$31,MATCH(ROW()-ROW($AH$11),$AH$12:$AH$34,0)))</TD></TR><TR><TD>S28</TD><TD>=IF(ISERROR(RIGHT(F28,LEN(F28)-FIND("*",SUBSTITUTE(F28," ","*",LEN(F28)-LEN(SUBSTITUTE(F28," ","")))))),"",RIGHT(F28,LEN(F28)-FIND("*",SUBSTITUTE(F28," ","*",LEN(F28)-LEN(SUBSTITUTE(F28," ",""))))))</TD></TR><TR><TD>T28</TD><TD>=IF(ISERROR(LEFT(F28,FIND(" ",F28)-1)),F28,(LEFT(F28,FIND(" ",F28)-1)))</TD></TR><TR><TD>U28</TD><TD>=T28& " "&S28</TD></TR><TR><TD>AA28</TD><TD>=IF(S28="",0,COUNTIF($S$12:$S$35,"<"&S28))</TD></TR><TR><TD>AB28</TD><TD>=IF(T28="",0,COUNTIF($T$12:$T$35,"<"&T28))</TD></TR><TR><TD>AC28</TD><TD>=IF(F28="",0,COUNTIF($F$12:$F$35,"<"&F28))</TD></TR><TR><TD>AD28</TD><TD>=RANK(G28,$G$12:$G$34)+COUNTIF($G$12:G28,G28)-1</TD></TR><TR><TD>AE28</TD><TD>=IF(H28="",0,COUNTIF($H$12:$H$35,"<"&H28))</TD></TR><TR><TD>AF28</TD><TD>=IF(I28="",0,COUNTIF($I$12:$I$35,"<"&I28))</TD></TR><TR><TD>AG28</TD><TD>=AA28*100000000000+AB28*1000000000+AD28*1000000+AE28*1000+AF28</TD></TR><TR><TD>AH28</TD><TD>=COUNT(AG$12:AG$34)-(RANK(AG28,AG$12:AG$34)+COUNTIF(AG$12:AG28,AG28))+2</TD></TR><TR><TD>AI28</TD><TD>=IF(AH28="","",INDEX($F$12:$F$34,MATCH(ROW()-ROW($AH$11),$AH$12:$AH$34,0)))</TD></TR><TR><TD>AJ28</TD><TD>=IF(AI28="","",INDEX($G$12:$G$34,MATCH(ROW()-ROW($AH$11),$AH$12:$AH$34,0)))</TD></TR><TR><TD>AK28</TD><TD>=IF(AH28="","",INDEX($H$12:$H$34,MATCH(ROW()-ROW($AH$11),$AH$12:$AH$34,0)))</TD></TR><TR><TD>AL28</TD><TD>=IF(AH28="","",INDEX($I$12:$I$31,MATCH(ROW()-ROW($AH$11),$AH$12:$AH$34,0)))</TD></TR><TR><TD>S29</TD><TD>=IF(ISERROR(RIGHT(F29,LEN(F29)-FIND("*",SUBSTITUTE(F29," ","*",LEN(F29)-LEN(SUBSTITUTE(F29," ","")))))),"",RIGHT(F29,LEN(F29)-FIND("*",SUBSTITUTE(F29," ","*",LEN(F29)-LEN(SUBSTITUTE(F29," ",""))))))</TD></TR><TR><TD>T29</TD><TD>=IF(ISERROR(LEFT(F29,FIND(" ",F29)-1)),F29,(LEFT(F29,FIND(" ",F29)-1)))</TD></TR><TR><TD>U29</TD><TD>=T29& " "&S29</TD></TR><TR><TD>AA29</TD><TD>=IF(S29="",0,COUNTIF($S$12:$S$35,"<"&S29))</TD></TR><TR><TD>AB29</TD><TD>=IF(T29="",0,COUNTIF($T$12:$T$35,"<"&T29))</TD></TR><TR><TD>AC29</TD><TD>=IF(F29="",0,COUNTIF($F$12:$F$35,"<"&F29))</TD></TR><TR><TD>AD29</TD><TD>=RANK(G29,$G$12:$G$34)+COUNTIF($G$12:G29,G29)-1</TD></TR><TR><TD>AE29</TD><TD>=IF(H29="",0,COUNTIF($H$12:$H$35,"<"&H29))</TD></TR><TR><TD>AF29</TD><TD>=IF(I29="",0,COUNTIF($I$12:$I$35,"<"&I29))</TD></TR><TR><TD>AG29</TD><TD>=AA29*100000000000+AB29*1000000000+AD29*1000000+AE29*1000+AF29</TD></TR><TR><TD>AH29</TD><TD>=COUNT(AG$12:AG$34)-(RANK(AG29,AG$12:AG$34)+COUNTIF(AG$12:AG29,AG29))+2</TD></TR><TR><TD>AI29</TD><TD>=IF(AH29="","",INDEX($F$12:$F$34,MATCH(ROW()-ROW($AH$11),$AH$12:$AH$34,0)))</TD></TR><TR><TD>AJ29</TD><TD>=IF(AI29="","",INDEX($G$12:$G$34,MATCH(ROW()-ROW($AH$11),$AH$12:$AH$34,0)))</TD></TR><TR><TD>AK29</TD><TD>=IF(AH29="","",INDEX($H$12:$H$34,MATCH(ROW()-ROW($AH$11),$AH$12:$AH$34,0)))</TD></TR><TR><TD>AL29</TD><TD>=IF(AH29="","",INDEX($I$12:$I$31,MATCH(ROW()-ROW($AH$11),$AH$12:$AH$34,0)))</TD></TR><TR><TD>S30</TD><TD>=IF(ISERROR(RIGHT(F30,LEN(F30)-FIND("*",SUBSTITUTE(F30," ","*",LEN(F30)-LEN(SUBSTITUTE(F30," ","")))))),"",RIGHT(F30,LEN(F30)-FIND("*",SUBSTITUTE(F30," ","*",LEN(F30)-LEN(SUBSTITUTE(F30," ",""))))))</TD></TR><TR><TD>T30</TD><TD>=IF(ISERROR(LEFT(F30,FIND(" ",F30)-1)),F30,(LEFT(F30,FIND(" ",F30)-1)))</TD></TR><TR><TD>U30</TD><TD>=T30& " "&S30</TD></TR><TR><TD>AA30</TD><TD>=IF(S30="",0,COUNTIF($S$12:$S$35,"<"&S30))</TD></TR><TR><TD>AB30</TD><TD>=IF(T30="",0,COUNTIF($T$12:$T$35,"<"&T30))</TD></TR><TR><TD>AC30</TD><TD>=IF(F30="",0,COUNTIF($F$12:$F$35,"<"&F30))</TD></TR><TR><TD>AD30</TD><TD>=RANK(G30,$G$12:$G$34)+COUNTIF($G$12:G30,G30)-1</TD></TR><TR><TD>AE30</TD><TD>=IF(H30="",0,COUNTIF($H$12:$H$35,"<"&H30))</TD></TR><TR><TD>AF30</TD><TD>=IF(I30="",0,COUNTIF($I$12:$I$35,"<"&I30))</TD></TR><TR><TD>AG30</TD><TD>=AA30*100000000000+AB30*1000000000+AD30*1000000+AE30*1000+AF30</TD></TR><TR><TD>AH30</TD><TD>=COUNT(AG$12:AG$34)-(RANK(AG30,AG$12:AG$34)+COUNTIF(AG$12:AG30,AG30))+2</TD></TR><TR><TD>AI30</TD><TD>=IF(AH30="","",INDEX($F$12:$F$34,MATCH(ROW()-ROW($AH$11),$AH$12:$AH$34,0)))</TD></TR><TR><TD>AJ30</TD><TD>=IF(AI30="","",INDEX($G$12:$G$34,MATCH(ROW()-ROW($AH$11),$AH$12:$AH$34,0)))</TD></TR><TR><TD>AK30</TD><TD>=IF(AH30="","",INDEX($H$12:$H$34,MATCH(ROW()-ROW($AH$11),$AH$12:$AH$34,0)))</TD></TR><TR><TD>AL30</TD><TD>=IF(AH30="","",INDEX($I$12:$I$31,MATCH(ROW()-ROW($AH$11),$AH$12:$AH$34,0)))</TD></TR><TR><TD>S31</TD><TD>=IF(ISERROR(RIGHT(F31,LEN(F31)-FIND("*",SUBSTITUTE(F31," ","*",LEN(F31)-LEN(SUBSTITUTE(F31," ","")))))),"",RIGHT(F31,LEN(F31)-FIND("*",SUBSTITUTE(F31," ","*",LEN(F31)-LEN(SUBSTITUTE(F31," ",""))))))</TD></TR><TR><TD>T31</TD><TD>=IF(ISERROR(LEFT(F31,FIND(" ",F31)-1)),F31,(LEFT(F31,FIND(" ",F31)-1)))</TD></TR><TR><TD>U31</TD><TD>=T31& " "&S31</TD></TR><TR><TD>AA31</TD><TD>=IF(S31="",0,COUNTIF($S$12:$S$35,"<"&S31))</TD></TR><TR><TD>AB31</TD><TD>=IF(T31="",0,COUNTIF($T$12:$T$35,"<"&T31))</TD></TR><TR><TD>AC31</TD><TD>=IF(F31="",0,COUNTIF($F$12:$F$35,"<"&F31))</TD></TR><TR><TD>AD31</TD><TD>=RANK(G31,$G$12:$G$34)+COUNTIF($G$12:G31,G31)-1</TD></TR><TR><TD>AE31</TD><TD>=IF(H31="",0,COUNTIF($H$12:$H$35,"<"&H31))</TD></TR><TR><TD>AF31</TD><TD>=IF(I31="",0,COUNTIF($I$12:$I$35,"<"&I31))</TD></TR><TR><TD>AG31</TD><TD>=AA31*100000000000+AB31*1000000000+AD31*1000000+AE31*1000+AF31</TD></TR><TR><TD>AH31</TD><TD>=COUNT(AG$12:AG$34)-(RANK(AG31,AG$12:AG$34)+COUNTIF(AG$12:AG31,AG31))+2</TD></TR><TR><TD>AI31</TD><TD>=IF(AH31="","",INDEX($F$12:$F$34,MATCH(ROW()-ROW($AH$11),$AH$12:$AH$34,0)))</TD></TR><TR><TD>AJ31</TD><TD>=IF(AI31="","",INDEX($G$12:$G$34,MATCH(ROW()-ROW($AH$11),$AH$12:$AH$34,0)))</TD></TR><TR><TD>AK31</TD><TD>=IF(AH31="","",INDEX($H$12:$H$34,MATCH(ROW()-ROW($AH$11),$AH$12:$AH$34,0)))</TD></TR><TR><TD>AL31</TD><TD>=IF(AH31="","",INDEX($I$12:$I$31,MATCH(ROW()-ROW($AH$11),$AH$12:$AH$34,0)))</TD></TR><TR><TD>AI32</TD><TD>=IF(AH32="","",INDEX($F$12:$F$34,MATCH(ROW()-ROW($AH$11),$AH$12:$AH$34,0)))</TD></TR><TR><TD>AJ32</TD><TD>=IF(AI32="","",INDEX($G$12:$G$34,MATCH(ROW()-ROW($AH$11),$AH$12:$AH$34,0)))</TD></TR><TR><TD>AK32</TD><TD>=IF(AH32="","",INDEX($H$12:$H$34,MATCH(ROW()-ROW($AH$11),$AH$12:$AH$34,0)))</TD></TR><TR><TD>AL32</TD><TD>=IF(AH32="","",INDEX($I$12:$I$31,MATCH(ROW()-ROW($AH$11),$AH$12:$AH$34,0)))</TD></TR><TR><TD>AI33</TD><TD>=IF(AH33="","",INDEX($F$12:$F$34,MATCH(ROW()-ROW($AH$11),$AH$12:$AH$34,0)))</TD></TR><TR><TD>AJ33</TD><TD>=IF(AI33="","",INDEX($G$12:$G$34,MATCH(ROW()-ROW($AH$11),$AH$12:$AH$34,0)))</TD></TR><TR><TD>AK33</TD><TD>=IF(AH33="","",INDEX($H$12:$H$34,MATCH(ROW()-ROW($AH$11),$AH$12:$AH$34,0)))</TD></TR><TR><TD>AL33</TD><TD>=IF(AH33="","",INDEX($I$12:$I$31,MATCH(ROW()-ROW($AH$11),$AH$12:$AH$34,0)))</TD></TR><TR><TD>AI34</TD><TD>=IF(AH34="","",INDEX($F$12:$F$34,MATCH(ROW()-ROW($AH$11),$AH$12:$AH$34,0)))</TD></TR><TR><TD>AJ34</TD><TD>=IF(AI34="","",INDEX($G$12:$G$34,MATCH(ROW()-ROW($AH$11),$AH$12:$AH$34,0)))</TD></TR><TR><TD>AK34</TD><TD>=IF(AH34="","",INDEX($H$12:$H$34,MATCH(ROW()-ROW($AH$11),$AH$12:$AH$34,0)))</TD></TR><TR><TD>AL34</TD><TD>=IF(AH34="","",INDEX($I$12:$I$31,MATCH(ROW()-ROW($AH$11),$AH$12:$AH$34,0)))</TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE>
</o:p>
<o:p></o:p>
Your help would be greatly appreciated.<o:p></o:p>
<o:p></o:p>
<o:p></o:p>
<o:p></o:p>
Kind Regards,<o:p></o:p>
<o:p></o:p>
Biz
 
Last edited:

Excel Facts

Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.
Sort by date Sort by votes
It's doing non-standard math on non-consecutive columns. If there's a simpler way to do it, I certainly can't think of it.

If it was 12, 9, 6, 3 in consecutive cells, then it's doable. As is, not so much.
 
Upvote 0
You must log in or register to reply here.

Similar threads

S
  • Question
Unexpected and inconsistent error with ranking rows based on criteria
Replies
2
Views
98
strugglingaccountant
S
M
  • Solved
Find Groups and Highlight them
2
Replies
10
Views
390
Peter_SSs
Peter_SSs
J
  • Solved
IF Function Formula Multiple Criteria
Replies
3
Views
111
Peter_SSs
Peter_SSs
W
  • Solved
Formula help
Replies
5
Views
178
Fluff
Fluff
N
  • Locked
  • Question
Exccel - date formula that drives multiple other formulas
Replies
2
Views
117
Fluff
Fluff

Forum statistics

Threads
1,214,651
Messages
6,120,738
Members
448,988
Latest member
BB_Unlv

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