ShaunKrane
New Member
- Joined
- Mar 25, 2013
- Messages
- 7
Greetings,
So here is my problem. I have been trying to locate a formula that will give me a accurate name of a person that has the lowest score in a particular location and another formula to get me the name of the largest score in a particular location.
In the table need a result for each location with the score that the manager has.
INDEX(B2:B449) = Persons Name
MATCH(Sheet1!A2,OM!A2:A93,0)) = Site Location
Below is an example of what I am needing and the data table that I am retrieving the results from.
<TBODY>
</TBODY><COLGROUP><COL><COL><COL><COL><COL></COLGROUP>
<TBODY>
</TBODY><COLGROUP><COL><COL><COL><COL><COL></COLGROUP>
So here is my problem. I have been trying to locate a formula that will give me a accurate name of a person that has the lowest score in a particular location and another formula to get me the name of the largest score in a particular location.
In the table need a result for each location with the score that the manager has.
INDEX(B2:B449) = Persons Name
MATCH(Sheet1!A2,OM!A2:A93,0)) = Site Location
Below is an example of what I am needing and the data table that I am retrieving the results from.
| Location Name</SPAN> | Manager w/ Lowest Score</SPAN> | Score</SPAN> | Manager w/ Highest Score</SPAN> | Score</SPAN> |
| Bacolod City Phil(One Sanparq)</SPAN> | Dennis Limitares</SPAN> | 67.57%</SPAN> | Mark Francis Millan</SPAN> | 100.00%</SPAN> |
| Barreal de Heredia Costa Rica</SPAN> | Natalia Elizondo</SPAN> | 36.31%</SPAN> | Bryan Aguero</SPAN> | 89.04%</SPAN> |
| Brownsville TX</SPAN> | Norma Silva</SPAN> | 51.72%</SPAN> | Cathy Cassels</SPAN> | 81.82%</SPAN> |
<TBODY>
</TBODY><COLGROUP><COL><COL><COL><COL><COL></COLGROUP>
| SITE</SPAN> | MANAGER</SPAN> | AGENT ATTENDANCE</SPAN> | AGENTS W/ RGU</SPAN> | ZERO RGU %</SPAN> |
| Bacolod City Phil(One Sanparq)</SPAN> | Nemesio de la Peña III</SPAN> | 110</SPAN> | 30</SPAN> | 72.73%</SPAN> |
| Bacolod City Phil(One Sanparq)</SPAN> | Philip Camil Gomez</SPAN> | 100</SPAN> | 7</SPAN> | 93.00%</SPAN> |
| Bacolod City Phil(One Sanparq)</SPAN> | Dennis Limitares</SPAN> | 222</SPAN> | 72</SPAN> | 67.57%</SPAN> |
| Bacolod City Phil(One Sanparq)</SPAN> | Joseph Prisco Milo</SPAN> | 72</SPAN> | 20</SPAN> | 72.22%</SPAN> |
| Bacolod City Phil(One Sanparq)</SPAN> | Sharon Flores</SPAN> | 160</SPAN> | 38</SPAN> | 76.25%</SPAN> |
| Barreal de Heredia Costa Rica</SPAN> | Alexander Quesada</SPAN> | 94</SPAN> | 14</SPAN> | 85.11%</SPAN> |
| Barreal de Heredia Costa Rica</SPAN> | Diana Quesada</SPAN> | 169</SPAN> | 58</SPAN> | 65.68%</SPAN> |
| Barreal de Heredia Costa Rica</SPAN> | Natalia Elizondo</SPAN> | 157</SPAN> | 100</SPAN> | 36.31%</SPAN> |
| Barreal de Heredia Costa Rica</SPAN> | Christine Redondo</SPAN> | 32</SPAN> | 3</SPAN> | 90.63%</SPAN> |
| Barreal de Heredia Costa Rica</SPAN> | Bryan Aguero</SPAN> | 146</SPAN> | 16</SPAN> | 89.04%</SPAN> |
| Barreal de Heredia Costa Rica</SPAN> | Eugenio Barrantes Miranda</SPAN> | 34</SPAN> | 5</SPAN> | 85.29%</SPAN> |
| Brownsville TX</SPAN> | Cathy Cassels</SPAN> | 11</SPAN> | 2</SPAN> | 81.82%</SPAN> |
| Brownsville TX</SPAN> | Luciano Mendiola</SPAN> | 116</SPAN> | 48</SPAN> | 58.62%</SPAN> |
| Brownsville TX</SPAN> | Norma Silva</SPAN> | 116</SPAN> | 56</SPAN> | 51.72%</SPAN> |
| Brownsville TX</SPAN> | Michael Brown</SPAN> | 19</SPAN> | 7</SPAN> | 63.16%</SPAN> |
| Brownsville TX</SPAN> | Guadalupe Moran</SPAN> | 111</SPAN> | 46</SPAN> | 58.56%</SPAN> |
| Cebu City Phil (Asiatown TGU)</SPAN> | Roxanne Joy Cabusas</SPAN> | 112</SPAN> | 3</SPAN> | 97.32%</SPAN> |
| Cebu City Phil (Asiatown TGU)</SPAN> | Ailyn Cruzada</SPAN> | 117</SPAN> | 5</SPAN> | 95.73%</SPAN> |
| Cebu City Phil (Asiatown TGU)</SPAN> | Rendell Rhodessa Codizar</SPAN> | 97</SPAN> | 1</SPAN> | 98.97%</SPAN> |
| Cebu City Phil (Asiatown TGU)</SPAN> | Arman Gines</SPAN> | 96</SPAN> | 3</SPAN> | 96.88%</SPAN> |
| Cebu City Phil (Asiatown TGU)</SPAN> | Moanna Marie Aranas</SPAN> | 50</SPAN> | 5</SPAN> | 90.00%</SPAN> |
| Cebu City Phil (Asiatown TGU)</SPAN> | Cecilio Vasquez Jr.</SPAN> | 111</SPAN> | 57</SPAN> | 48.65%</SPAN> |
| Cebu City Phil (Asiatown TGU)</SPAN> | Einstein James Langub</SPAN> | 55</SPAN> | 1</SPAN> | 98.18%</SPAN> |
| Cebu City Phil (Asiatown TGU)</SPAN> | James Diayon</SPAN> | 89</SPAN> | 5</SPAN> | 94.38%</SPAN> |
| Cebu City Phil (Asiatown TGU)</SPAN> | Raffy Tantuico</SPAN> | 214</SPAN> | 65</SPAN> | 69.63%</SPAN> |
| Cebu City Phil (Asiatown TGU)</SPAN> | Rena Oacan</SPAN> | 112</SPAN> | 4</SPAN> | 96.43%</SPAN> |
| Cebu City Phil (Asiatown TGU)</SPAN> | Sharon Knight</SPAN> | 11</SPAN> | 0</SPAN> | 100.00%</SPAN> |
| Home Agent Organization</SPAN> | Santos Ruiz</SPAN> | 68</SPAN> | 4</SPAN> | 94.12%</SPAN> |
| Home Agent Organization</SPAN> | Thomas Clancy</SPAN> | 35</SPAN> | 10</SPAN> | 71.43%</SPAN> |
| Home Agent Organization</SPAN> | Lisa Stanley</SPAN> | 168</SPAN> | 65</SPAN> | 61.31%</SPAN> |
| Home Agent Organization</SPAN> | Adrienne Hodgen</SPAN> | 250</SPAN> | 90</SPAN> | 64.00%</SPAN> |
| Home Agent Organization</SPAN> | Dennis Bilow</SPAN> | 131</SPAN> | 48</SPAN> | 63.36%</SPAN> |
| Laredo TX</SPAN> | Juan Guzman</SPAN> | 124</SPAN> | 58</SPAN> | 53.23%</SPAN> |
| Laredo TX</SPAN> | Abigail Cruz</SPAN> | 132</SPAN> | 56</SPAN> | 57.58%</SPAN> |
| Laredo TX</SPAN> | Narinder Pagarani</SPAN> | 127</SPAN> | 20</SPAN> | 84.25%</SPAN> |
| Laredo TX</SPAN> | Marcelino Estrada</SPAN> | 60</SPAN> | 11</SPAN> | 81.67%</SPAN> |
| Laredo TX</SPAN> | Victor Franco</SPAN> | 113</SPAN> | 52</SPAN> | 53.98%</SPAN> |
| Laredo TX</SPAN> | Patti Torres</SPAN> | 272</SPAN> | 112</SPAN> | 58.82%</SPAN> |
| Laredo TX</SPAN> | Isaias Lopez</SPAN> | 20</SPAN> | 9</SPAN> | 55.00%</SPAN> |
| Laredo TX</SPAN> | Marcos Ariaz</SPAN> | 91</SPAN> | 30</SPAN> | 67.03%</SPAN> |
| Logan UT</SPAN> | Helena Thiele</SPAN> | 171</SPAN> | 11</SPAN> | 93.57%</SPAN> |
| Logan UT</SPAN> | Maighan Wagstaff</SPAN> | 69</SPAN> | 9</SPAN> | 86.96%</SPAN> |
| Logan UT</SPAN> | Steven Short</SPAN> | 10</SPAN> | 2</SPAN> | 80.00%</SPAN> |
| Logan UT</SPAN> | Jennifer Denton</SPAN> | 98</SPAN> | 44</SPAN> | 55.10%</SPAN> |
| Logan UT</SPAN> | M Buys</SPAN> | 17</SPAN> | 2</SPAN> | 88.24%</SPAN> |
| Logan UT</SPAN> | Zachary Passey</SPAN> | 110</SPAN> | 47</SPAN> | 57.27%</SPAN> |
| Lubbock TX</SPAN> | Criselda Fernandez</SPAN> | 120</SPAN> | 76</SPAN> | 36.67%</SPAN> |
| Lubbock TX</SPAN> | Thomas Cundiff</SPAN> | 125</SPAN> | 79</SPAN> | 36.80%</SPAN> |
| Lubbock TX</SPAN> | Michael Herald</SPAN> | 89</SPAN> | 38</SPAN> | 57.30%</SPAN> |
| Lubbock TX</SPAN> | John Simek</SPAN> | 131</SPAN> | 53</SPAN> | 59.54%</SPAN> |
| Lubbock TX</SPAN> | Johnny Rodriguez</SPAN> | 138</SPAN> | 58</SPAN> | 57.97%</SPAN> |
| Lubbock TX</SPAN> | Santos Flores</SPAN> | 26</SPAN> | 8</SPAN> | 69.23%</SPAN> |
| Manila/Sta. Cruz Philippines</SPAN> | David Benjamin Tan</SPAN> | 117</SPAN> | 13</SPAN> | 88.89%</SPAN> |
| Manila/Sta. Cruz Philippines</SPAN> | Sheryll Lyn Lai</SPAN> | 66</SPAN> | 19</SPAN> | 71.21%</SPAN> |
| Manila/Sta. Cruz Philippines</SPAN> | Gilmore Demdam</SPAN> | 88</SPAN> | 26</SPAN> | 70.45%</SPAN> |
| Manila/Sta. Cruz Philippines</SPAN> | Judeo Pagarao</SPAN> | 100</SPAN> | 27</SPAN> | 73.00%</SPAN> |
| Manila/Sta. Cruz Philippines</SPAN> | Emil Martin</SPAN> | 88</SPAN> | 23</SPAN> | 73.86%</SPAN> |
| Manila/Sta. Cruz Philippines</SPAN> | Ethelbert Chang</SPAN> | 26</SPAN> | 7</SPAN> | 73.08%</SPAN> |
| Pasig City Phil (Robinsons)</SPAN> | Christian Martin</SPAN> | 30</SPAN> | 1</SPAN> | 96.67%</SPAN> |
| Pasig City Phil (Robinsons)</SPAN> | Marlon Tan</SPAN> | 75</SPAN> | 47</SPAN> | 37.33%</SPAN> |
| Pasig City Phil (Robinsons)</SPAN> | Rosauro Misayah</SPAN> | 86</SPAN> | 49</SPAN> | 43.02%</SPAN> |
| Pasig City Phil (Robinsons)</SPAN> | Juan Carlos Ragaza</SPAN> | 63</SPAN> | 35</SPAN> | 44.44%</SPAN> |
| Pasig City Phil (Robinsons)</SPAN> | Willechellee Tan-Lenon</SPAN> | 70</SPAN> | 33</SPAN> | 52.86%</SPAN> |
| Pasig City Phil (Robinsons)</SPAN> | Joannah Ruth Andaya</SPAN> | 63</SPAN> | 41</SPAN> | 34.92%</SPAN> |
| St. John's Newfound (Torbay)</SPAN> | Scott Kavanagh</SPAN> | 57</SPAN> | 24</SPAN> | 57.89%</SPAN> |
| St. John's Newfound (Torbay)</SPAN> | Gina Meyers</SPAN> | 11</SPAN> | 2</SPAN> | 81.82%</SPAN> |
| St. John's Newfound (Torbay)</SPAN> | Cory Legge</SPAN> | 49</SPAN> | 8</SPAN> | 83.67%</SPAN> |
| Tucson AZ (Business)</SPAN> | Matthew Orman</SPAN> | 154</SPAN> | 56</SPAN> | 63.64%</SPAN> |
| Tucson AZ (Business)</SPAN> | Geomara Armenta</SPAN> | 10</SPAN> | 3</SPAN> | 70.00%</SPAN> |
| Tucson AZ (Business)</SPAN> | Cynthia Marquez</SPAN> | 98</SPAN> | 13</SPAN> | 86.73%</SPAN> |
<TBODY>
</TBODY><COLGROUP><COL><COL><COL><COL><COL></COLGROUP>
