Index Match Small and Index Match Large

[ShaunKrane]

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.

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>

 

[Andrew Poulsom]

Welcome to MrExcel.

With your second table in the range G1:K4, in H2 confirmed with Ctrl+Shift+Enter and copied down:

=INDEX(B$2:B$449,MATCH(TRUE,MIN(IF(A$2:A$449=G2,E$2:E$449))=((A$2:A$449=G2)*(E$2:E$449)),FALSE))

and in I2 confirmed with Ctrl+Shift+Enter and copied down:

=MIN(IF(A$2:A$449=G2,E$2:E$449))

For the max change MIN to MAX.

 

[ShaunKrane]

Thank you Andrew. This worked great for the information I have listed below. When I reuse the formula and change the criteria for another sheet I am getting names in the wrong order that are not matching the correct location.


=INDEX(TL!$B$2:$B$449,MATCH(TRUE,MIN(IF(TL!$A$2:$A$449=TL!G2,TL!$E$2:$E$449))=((TL!$A$2:$A$449=TL!G2)*(TL!$E$2:$E$449)),FALSE))

SITE	TEAM LEADER	AGENT ATTENDANCE	AGENTS W/ RGU	ZERO RGU %		LOCATION	TL	RGU%
Bacolod City Phil(One Sanparq)	Alfred Salon	16	7	56.25%		Bacolod City Phil(One Sanparq)	Ma. Theresa Camon	46.15%
Bacolod City Phil(One Sanparq)	Anna Rose Perocho	16	5	68.75%		Barreal de Heredia Costa Rica	Alfredo Lopez	21.43%
Bacolod City Phil(One Sanparq)	Cherryl Choresca	18	3	83.33%		Brownsville TX	Francisco Vasquez	26.67%
Bacolod City Phil(One Sanparq)	Kareen Lagrazon	22	4	81.82%		Cebu City Phil (Asiatown TGU)	Marvin Anthony Mueva	9.09%
Bacolod City Phil(One Sanparq)	John Dexter Husain	17	6	64.71%		Home Agent Org Staff US Zone A	Dennis Bilow	100.00%
Bacolod City Phil(One Sanparq)	Jincky Sales	17	1	94.12%		Home Agent Organization	Megan Anderson	36.84%
Bacolod City Phil(One Sanparq)	Sheila Mae Falconite	17	9	47.06%		Laredo TX	Laura Guerrero	22.22%
Bacolod City Phil(One Sanparq)	Dennis Limitares	37	18	51.35%		Logan UT	Kyle Muir	20.00%
Bacolod City Phil(One Sanparq)	Emerson Nang	15	1	93.33%		Lubbock TX	Javier Galindo	17.65%
Bacolod City Phil(One Sanparq)	Pia Violeta Canillas	17	6	64.71%		Manila/Sta. Cruz Philippines	Daniel Olardo	28.57%
Bacolod City Phil(One Sanparq)	Katrina Kenji Uy	37	5	86.49%		Pasig City Phil (Robinsons)	Mark Jason Manubay	9.09%
Bacolod City Phil(One Sanparq)	Precilla Libertad	33	1	96.97%		St. John's Newfound (Torbay)	Alfred Salon	56.25%
Bacolod City Phil(One Sanparq)	Cheryl Jade Elix	17	5	70.59%		Tucson AZ (Business)	Alfred Salon	56.25%
Bacolod City Phil(One Sanparq)	Rodolfo II Viva	16	8	50.00%
Bacolod City Phil(One Sanparq)	Rolen Espera	16	8	50.00%
Bacolod City Phil(One Sanparq)	Benjie Longno	14	2	85.71%
Bacolod City Phil(One Sanparq)	Myra Demonteverde	15	2	86.67%
Bacolod City Phil(One Sanparq)	John Rey Rosales	16	6	62.50%
Bacolod City Phil(One Sanparq)	Dax Sorbito	14	5	64.29%
Bacolod City Phil(One Sanparq)	Marie Cris Fernandez	14	3	78.57%
Bacolod City Phil(One Sanparq)	Rovel John Jusdin	20	6	70.00%
Bacolod City Phil(One Sanparq)	Nemesio de la Peña III	5	1	80.00%
Bacolod City Phil(One Sanparq)	Harold Mendoza	13	1	92.31%
Bacolod City Phil(One Sanparq)	Sharon Flores	4	0	100.00%
Bacolod City Phil(One Sanparq)	Jan-Jason Ferrer	16	4	75.00%
Bacolod City Phil(One Sanparq)	Niño Olimpo	14	4	71.43%
Bacolod City Phil(One Sanparq)	Francis Omar Tabligan	16	7	56.25%
Bacolod City Phil(One Sanparq)	Jocelyn Gernalin	19	1	94.74%
Bacolod City Phil(One Sanparq)	Bernie Lloyd Lamela	14	5	64.29%
Bacolod City Phil(One Sanparq)	Nestor Cacanando	15	5	66.67%
Bacolod City Phil(One Sanparq)	Marvi Pioquinto	12	1	91.67%
Bacolod City Phil(One Sanparq)	Beverly Tabo	17	0	100.00%
Bacolod City Phil(One Sanparq)	Ma. Theresa Camon	13	7	46.15%
Bacolod City Phil(One Sanparq)	Runel Vingno	15	3	80.00%
Bacolod City Phil(One Sanparq)	Ramon Pocholo Segovia	17	3	82.35%
Bacolod City Phil(One Sanparq)	Judylin Murillo	18	6	66.67%
Bacolod City Phil(One Sanparq)	Philip Camil Gomez	6	1	83.33%
Bacolod City Phil(One Sanparq)	Rose Ann Alipato	11	0	100.00%
Bacolod City Phil(One Sanparq)	Grace Soberano	15	4	73.33%
Bacolod City Phil(One Sanparq)	Jean Michel Paolo Gonzaga	19	3	84.21%
Bacolod City Phil(One Sanparq)	Angeline Grace Grandez	1	0	100.00%
Bacolod City Phil(One Sanparq)	Marlo Kyn Bunda	1	0	100.00%
Bacolod City Phil(One Sanparq)	Mischelle Dungon	1	0	100.00%
Bacolod City Phil(One Sanparq)	Easter Marie Javellana	1	0	100.00%
Bacolod City Phil(One Sanparq)	Rizi Rivera	1	0	100.00%
Barreal de Heredia Costa Rica	Ronny Castillo	23	11	52.17%
Barreal de Heredia Costa Rica	Josue Mora	18	1	94.44%
Barreal de Heredia Costa Rica	Erin Quiros	18	3	83.33%
Barreal de Heredia Costa Rica	Cesar Farguharson	18	0	100.00%
Barreal de Heredia Costa Rica	Leonardo Guillen	18	11	38.89%
Barreal de Heredia Costa Rica	Josue Taylor Stewart	21	3	85.71%
Barreal de Heredia Costa Rica	Ruperto Tucker	16	1	93.75%
Barreal de Heredia Costa Rica	Jorge Molina	18	2	88.89%
Barreal de Heredia Costa Rica	Carlos Wilson Pearson	16	10	37.50%
Barreal de Heredia Costa Rica	Jonathan Otarola	18	12	33.33%
Barreal de Heredia Costa Rica	Fabricio Vargas	19	12	36.84%
Barreal de Heredia Costa Rica	Gabriel Solano Jimenez	20	1	95.00%
Barreal de Heredia Costa Rica	Ronny Zamora	16	2	87.50%
Barreal de Heredia Costa Rica	Jose Chaves	23	4	82.61%
Barreal de Heredia Costa Rica	Joel Noguera	1	0	100.00%
Barreal de Heredia Costa Rica	Dorian Ramirez	16	6	62.50%
Barreal de Heredia Costa Rica	Javier Garcia	18	3	83.33%
Barreal de Heredia Costa Rica	Maria Matamoros	20	14	30.00%
Barreal de Heredia Costa Rica	Frank Royes	15	7	53.33%
Barreal de Heredia Costa Rica	Jorge Martinez	17	2	88.24%
Barreal de Heredia Costa Rica	Christopher Mendoza	21	4	80.95%
Barreal de Heredia Costa Rica	Aaron Loaiza	19	1	94.74%
Barreal de Heredia Costa Rica	Eduardo Araya	20	10	50.00%
Barreal de Heredia Costa Rica	Alvaro Zamora	21	3	85.71%
Barreal de Heredia Costa Rica	Jorhan Loaiza	22	8	63.64%
Barreal de Heredia Costa Rica	Scarleth Tercero	19	3	84.21%
Barreal de Heredia Costa Rica	Kenneth Jones Castrillo	8	0	100.00%
Barreal de Heredia Costa Rica	David Vargas Chavarria	24	18	25.00%
Barreal de Heredia Costa Rica	Maureen Romero	16	11	31.25%
Barreal de Heredia Costa Rica	Andres Chavarria	16	4	75.00%
Barreal de Heredia Costa Rica	Alfredo Lopez	14	11	21.43%
Barreal de Heredia Costa Rica	Rebeca Acuna Blanco	19	2	89.47%
Barreal de Heredia Costa Rica	Jason Ruiz	18	3	83.33%
Barreal de Heredia Costa Rica	Eduardo Carballo	21	3	85.71%
Barreal de Heredia Costa Rica	Karent Bermudez Alpizar	21	10	52.38%
Barreal de Heredia Costa Rica	Bryan Aguero	4	1	75.00%
Barreal de Heredia Costa Rica	Natalia Elizondo	2	0	100.00%
Barreal de Heredia Costa Rica	Christine Redondo	2	0	100.00%
Barreal de Heredia Costa Rica	Jorge Zuniga	1	0	100.00%
Barreal de Heredia Costa Rica	Eugenio Barrantes Miranda	5	0	100.00%
Brownsville TX	Edgar Martinez	13	8	38.46%
Brownsville TX	Clara Marquez	15	7	53.33%
Brownsville TX	John Russell	11	6	45.45%
Brownsville TX	Marie Duque	16	7	56.25%
Brownsville TX	Jose Davila	15	7	53.33%
Brownsville TX	Augustus Spradling	16	7	56.25%
Brownsville TX	Oscar Martinez	14	6	57.14%
Brownsville TX	Jetshada Jaruboon	16	9	43.75%
Brownsville TX	Blanca Zurita	15	10	33.33%
Brownsville TX	Marcela Mireles	15	10	33.33%
Brownsville TX	Daniel Valdez	19	7	63.16%
Brownsville TX	Erika Duran	18	6	66.67%
Brownsville TX	Francisco Vasquez	15	11	26.67%
Brownsville TX	Brenda Padron	13	2	84.62%
Brownsville TX	Mariano Delgado	11	5	54.55%
Brownsville TX	Manuel Gutierrez	15	5	66.67%
Brownsville TX	Jose Garza	13	6	53.85%
Brownsville TX	Noe Guerrero	13	4	69.23%
Brownsville TX	Edith Obregon	12	6	50.00%
Brownsville TX	Jose Banuelos	15	3	80.00%
Brownsville TX	Joanna Roussett	15	4	73.33%
Brownsville TX	Norma Silva	4	1	75.00%
Brownsville TX	Jacqueline Torres	15	8	46.67%
Brownsville TX	Ann Erblich	15	4	73.33%
Brownsville TX	Rachael Moffitt	12	3	75.00%
Brownsville TX	Dane Prepejchal	15	6	60.00%
Brownsville TX	Guadalupe Moran	5	1	80.00%
Brownsville TX	Luciano Mendiola	2	0	100.00%
Cebu City Phil (Asiatown TGU)	Michelle Alicia Yu	19	0	100.00%
Cebu City Phil (Asiatown TGU)	Mila Jane Servania	15	0	100.00%
Cebu City Phil (Asiatown TGU)	Rotcelyn Abis	17	0	100.00%
Cebu City Phil (Asiatown TGU)	Julio Besana	35	12	65.71%
Cebu City Phil (Asiatown TGU)	Crullan Jumuad	17	0	100.00%
Cebu City Phil (Asiatown TGU)	Mark Anton Soontit	16	2	87.50%
Cebu City Phil (Asiatown TGU)	Catherine Vega	18	6	66.67%
Cebu City Phil (Asiatown TGU)	Isis Medillo	54	13	75.93%
Cebu City Phil (Asiatown TGU)	Trisha Eunice Libres	17	5	70.59%
Cebu City Phil (Asiatown TGU)	Joeson Alvarado	15	1	93.33%
Cebu City Phil (Asiatown TGU)	Adel Ondangan	17	9	47.06%
Cebu City Phil (Asiatown TGU)	Joseph Ariel Uy	38	13	65.79%
Cebu City Phil (Asiatown TGU)	Julie Rose Togonon	17	2	88.24%
Cebu City Phil (Asiatown TGU)	Foyer Garcia	19	0	100.00%
Cebu City Phil (Asiatown TGU)	Carol Abella	17	1	94.12%
Cebu City Phil (Asiatown TGU)	Christian Maurice De Jesus	16	0	100.00%
Cebu City Phil (Asiatown TGU)	Regienald Reyes	14	1	92.86%
Cebu City Phil (Asiatown TGU)	Analou Bequilla	20	1	95.00%
Cebu City Phil (Asiatown TGU)	Ronald San Diego	32	9	71.88%
Cebu City Phil (Asiatown TGU)	Russell Atamosa	18	1	94.44%
Cebu City Phil (Asiatown TGU)	Van Clark Maandig	19	0	100.00%
Cebu City Phil (Asiatown TGU)	Iris Panagsagan	17	0	100.00%
Cebu City Phil (Asiatown TGU)	Igmidio Madrid	12	1	91.67%
Cebu City Phil (Asiatown TGU)	Christian Joy Yu	17	0	100.00%
Cebu City Phil (Asiatown TGU)	June Verdida	18	1	94.44%
Cebu City Phil (Asiatown TGU)	Alex Hofilena	17	0	100.00%
Cebu City Phil (Asiatown TGU)	Sheryl Ann Rose Prado	19	1	94.74%
Cebu City Phil (Asiatown TGU)	Karl Eric Calamba	17	1	94.12%
Cebu City Phil (Asiatown TGU)	Chezy Closas	13	0	100.00%
Cebu City Phil (Asiatown TGU)	Dolor Bisuela	2	0	100.00%
Cebu City Phil (Asiatown TGU)	Jessica Mae Ansale	18	0	100.00%
Cebu City Phil (Asiatown TGU)	Darryl Brown	11	0	100.00%
Cebu City Phil (Asiatown TGU)	Divine Grace Ortiz	18	0	100.00%
Cebu City Phil (Asiatown TGU)	Mary Alginie Suarez	14	2	85.71%
Cebu City Phil (Asiatown TGU)	Rolan Coquilla	17	1	94.12%
Cebu City Phil (Asiatown TGU)	Lee Stephen Fat	16	0	100.00%
Cebu City Phil (Asiatown TGU)	Joe Frazier Jalandoon	18	9	50.00%
Cebu City Phil (Asiatown TGU)	Jenalynne Sioson	12	2	83.33%
Cebu City Phil (Asiatown TGU)	Juan Carlos Tantoco	14	2	85.71%
Cebu City Phil (Asiatown TGU)	Patrick Cabahug	16	0	100.00%
Cebu City Phil (Asiatown TGU)	Caesar Gabut	1	0	100.00%
Cebu City Phil (Asiatown TGU)	Dondon Howard Lucero	14	2	85.71%
Cebu City Phil (Asiatown TGU)	Rex Edgardo Wagas	18	0	100.00%
Cebu City Phil (Asiatown TGU)	Throy Elizan	16	1	93.75%
Cebu City Phil (Asiatown TGU)	Bernardo Manatad III	17	0	100.00%
Cebu City Phil (Asiatown TGU)	Emmanuel Thomas Cadungog	14	0	100.00%
Cebu City Phil (Asiatown TGU)	Laurenell Lois Jimenez	18	1	94.44%
Cebu City Phil (Asiatown TGU)	Joane Marie Zaragoza	20	1	95.00%
Cebu City Phil (Asiatown TGU)	Roel Malayao	18	0	100.00%
Cebu City Phil (Asiatown TGU)	Rendell Rhodessa Codizar	3	0	100.00%
Cebu City Phil (Asiatown TGU)	Marvin Anthony Mueva	11	10	9.09%
Cebu City Phil (Asiatown TGU)	Doreen Maricar Verano	15	0	100.00%
Cebu City Phil (Asiatown TGU)	Pearl Giselle Uno	8	0	100.00%
Cebu City Phil (Asiatown TGU)	Roxanne Joy Cabusas	1	0	100.00%
Cebu City Phil (Asiatown TGU)	Adrian Gabriel Babista	15	8	46.67%
Cebu City Phil (Asiatown TGU)	Carlos Christopher Yares	13	0	100.00%
Cebu City Phil (Asiatown TGU)	Joecito Niño Ada	13	1	92.31%
Cebu City Phil (Asiatown TGU)	Paul Francis Ansit	21	8	61.90%
Cebu City Phil (Asiatown TGU)	Ma. Eleanor Solano-Hiramis	17	11	35.29%
Cebu City Phil (Asiatown TGU)	Cindy Ngo	4	0	100.00%
Cebu City Phil (Asiatown TGU)	Jorlan Mercado	14	2	85.71%
Cebu City Phil (Asiatown TGU)	Aristotle John Asis	20	7	65.00%
Cebu City Phil (Asiatown TGU)	Ma. Catherine Magnaye	19	1	94.74%
Cebu City Phil (Asiatown TGU)	Arman Gines	5	0	100.00%
Cebu City Phil (Asiatown TGU)	Cliede Nino Castaneda	2	0	100.00%
Cebu City Phil (Asiatown TGU)	Marco Adrian Ador	12	0	100.00%
Cebu City Phil (Asiatown TGU)	Cristito Dona	13	0	100.00%
Cebu City Phil (Asiatown TGU)	Iris Diana	1	0	100.00%
Cebu City Phil (Asiatown TGU)	Cecilio Vasquez Jr.	1	0	100.00%
Cebu City Phil (Asiatown TGU)	Marry Grace Tapang	1	0	100.00%
Cebu City Phil (Asiatown TGU)	Anna Luisa Setubal	1	0	100.00%
Cebu City Phil (Asiatown TGU)	Noel Mark Lerio	1	0	100.00%
Cebu City Phil (Asiatown TGU)	Janice Rudila	2	0	100.00%
Cebu City Phil (Asiatown TGU)	Lindo Mark Mayol	1	0	100.00%
Cebu City Phil (Asiatown TGU)	Rollo Ferolino	1	0	100.00%
Cebu City Phil (Asiatown TGU)	Mario Cochero Jr.	1	0	100.00%
Home Agent Organization	Curt Banks	13	4	69.23%
Home Agent Organization	Peggie Tackett	20	8	60.00%
Home Agent Organization	Colleen Lewis	11	1	90.91%
Home Agent Organization	Nicolette McGuire	20	3	85.00%
Home Agent Organization	Lindsay Larkin	80	17	78.75%
Home Agent Organization	Amy O'Dell	19	11	42.11%
Home Agent Organization	Jose Vargas	36	3	91.67%
Home Agent Organization	Zachary Ash	8	3	62.50%
Home Agent Organization	Shannon Koenders	21	10	52.38%
Home Agent Organization	Denielle Johnson	21	5	76.19%
Home Agent Organization	Bradley Poe	14	4	71.43%
Home Agent Organization	David Jeppesen	9	3	66.67%
Home Agent Organization	Matthew Hall	12	4	66.67%
Home Agent Organization	Monica Lucovitz	22	8	63.64%
Home Agent Organization	Brandi Heinsohn	25	10	60.00%
Home Agent Organization	Joyce Scogin	14	2	85.71%
Home Agent Organization	Scott Miller	23	12	47.83%
Home Agent Organization	Wendy Kenney	17	10	41.18%
Home Agent Organization	Megan Anderson	19	12	36.84%
Home Agent Organization	Jessica Gatewood	17	2	88.24%
Home Agent Organization	Paul Platt	5	2	60.00%
Home Agent Organization	Katrina Thomsen	15	8	46.67%
Home Agent Organization	Linda Glass	25	14	44.00%
Home Agent Organization	Chantelle O'Docharty	30	13	56.67%
Home Agent Organization	Mary Howard	16	7	56.25%
Home Agent Organization	Christy Minard	20	8	60.00%
Home Agent Organization	Parker O'Brien	16	6	62.50%
Home Agent Organization	Rebecca Berger	15	4	73.33%
Home Agent Organization	Penny Dame	13	5	61.54%
Home Agent Organization	Joann Rodriguez	17	9	47.06%
Home Agent Organization	Geoff Clarke	11	3	72.73%
Laredo TX	Luis Cervantes	35	15	57.14%
Laredo TX	Rigoberto Morin	10	1	90.00%
Laredo TX	Roberto Limon	45	5	88.89%
Laredo TX	Allison Herrera	19	4	78.95%
Laredo TX	Adrian Lopez	20	8	60.00%
Laredo TX	Jose Reyna	18	8	55.56%
Laredo TX	Adrian Santos	14	7	50.00%
Laredo TX	Juan Martinez	12	7	41.67%
Laredo TX	Jill Schmigel	30	14	53.33%
Laredo TX	Jose Valdez	17	13	23.53%
Laredo TX	Esteban Garza	14	3	78.57%
Laredo TX	Juan Trevino	9	3	66.67%
Laredo TX	Albert Maldonado	53	14	73.58%
Laredo TX	Juan Siles	28	7	75.00%
Laredo TX	Benny Gonzalez	11	8	27.27%
Laredo TX	Efigenio Ortiz Jr.	13	5	61.54%
Laredo TX	Javier Contreras	14	7	50.00%
Laredo TX	Laura Guerrero	9	7	22.22%
Laredo TX	Junsub Meng	9	0	100.00%
Laredo TX	David Guevara	20	9	55.00%
Laredo TX	Jesus Covarrubias	17	6	64.71%
Laredo TX	Wendy Ramos	35	15	57.14%
Laredo TX	Cesar Santana	10	7	30.00%
Laredo TX	Jonathan Galvan	12	7	41.67%
Laredo TX	Michael Ortiz	6	4	33.33%
Laredo TX	Hector Ramirez	15	0	100.00%
Laredo TX	Raul Pena	21	2	90.48%
Laredo TX	Jose Arreola	18	10	44.44%
Laredo TX	Carlos Pacheco	17	6	64.71%
Laredo TX	Cristina Siles	13	5	61.54%
Laredo TX	Lorenzo Salazar	17	10	41.18%
Laredo TX	Michael Castillo	13	4	69.23%
Laredo TX	Eduardo Cavazos	19	8	57.89%
Laredo TX	Yanira Gonzalez	10	5	50.00%
Laredo TX	Melody Jones	12	3	75.00%
Laredo TX	Martha Estrada	12	2	83.33%
Laredo TX	Matthew Anaya	23	8	65.22%
Laredo TX	Michael Johnson	18	9	50.00%
Laredo TX	Eugenio Belmares	19	6	68.42%
Laredo TX	Solano Hernandez III	31	15	51.61%
Laredo TX	Rene Ventura	16	5	68.75%
Laredo TX	Edgar Garcia	13	3	76.92%
Laredo TX	Domingo Dominguez	1	0	100.00%
Laredo TX	William Salinas	22	2	90.91%
Laredo TX	Frances Andrade	15	6	60.00%
Laredo TX	Angel Villarreal	14	7	50.00%
Laredo TX	Christina Martinez	8	4	50.00%
Laredo TX	Daniela Guerra	23	11	52.17%
Laredo TX	Alfonso Hinojosa Jr.	4	2	50.00%
Laredo TX	Alberto Arizpe	7	0	100.00%
Laredo TX	Vanessa Medina	22	8	63.64%
Laredo TX	Luis Palacios	13	2	84.62%
Laredo TX	Mayra Mata	4	1	75.00%
Laredo TX	Jorge Morales	22	6	72.73%
Laredo TX	Isidro Medina	4	2	50.00%
Laredo TX	Guillermo Garza	17	2	88.24%
Laredo TX	Justin Magee	6	1	83.33%
Laredo TX	Jose Valadez	11	5	54.55%
Laredo TX	Antonio Ortiz	11	5	54.55%
Laredo TX	Patti Torres	1	0	100.00%
Laredo TX	Marcos Ariaz	4	0	100.00%
Laredo TX	Abigail Cruz	1	0	100.00%
Logan UT	Levi Leckie	24	2	91.67%
Logan UT	Michelle Johnson	22	0	100.00%
Logan UT	Philip Jackson	28	7	75.00%
Logan UT	Samuel Farnsworth	16	1	93.75%
Logan UT	Micah Coombs	20	4	80.00%
Logan UT	Elsha Esplin	17	1	94.12%
Logan UT	Tannin Pease	18	9	50.00%
Logan UT	Jeffrey Goodrich	21	1	95.24%
Logan UT	Amanda Cragun	15	0	100.00%
Logan UT	Joy Peterson	17	2	88.24%
Logan UT	Ethan Swenson	15	10	33.33%
Logan UT	Larry Peterson	14	5	64.29%
Logan UT	Martha Sandoval	17	3	82.35%
Logan UT	Danielle Anderson	22	1	95.45%
Logan UT	Aaron Rich	17	2	88.24%
Logan UT	Cameron Parker	11	7	36.36%
Logan UT	Kory Meng	11	8	27.27%
Logan UT	Randy Robins	15	4	73.33%
Logan UT	Katie Potter	11	5	54.55%
Logan UT	Michael Hulce	8	3	62.50%
Logan UT	Aubrie Zondler	17	2	88.24%
Logan UT	Stefania Jones	17	2	88.24%
Logan UT	Helena Thiele	5	1	80.00%
Logan UT	Emily Christensen	12	1	91.67%
Logan UT	Adam Cain	22	0	100.00%
Logan UT	Ben Hanna	15	7	53.33%
Logan UT	Zachary Passey	4	1	75.00%
Logan UT	Jackie Hirschi	17	9	47.06%
Logan UT	Raelin Wanner	16	9	43.75%
Logan UT	Kyle Muir	10	8	20.00%
Logan UT	Jennifer Denton	1	0	100.00%
Lubbock TX	Bambi Hebert	16	11	31.25%
Lubbock TX	Francisco Martinez-Manzanares	18	11	38.89%
Lubbock TX	Michelle McRorey	21	14	33.33%
Lubbock TX	Carla Benavides	20	14	30.00%
Lubbock TX	Paula Garcia	18	3	83.33%
Lubbock TX	Steve Navarro	19	12	36.84%
Lubbock TX	David Maciel	31	9	70.97%
Lubbock TX	Larry Pond	31	11	64.52%
Lubbock TX	Bonnie Turner	18	12	33.33%
Lubbock TX	Adam Newell	16	5	68.75%
Lubbock TX	Haley Dosher	15	7	53.33%
Lubbock TX	Kendra Toney	18	5	72.22%
Lubbock TX	Darla Rodgers	18	8	55.56%
Lubbock TX	Keith Young	14	6	57.14%
Lubbock TX	Javier Galindo	17	14	17.65%
Lubbock TX	Amanda Callison	13	6	53.85%
Lubbock TX	Michael Herald	5	2	60.00%
Lubbock TX	Esteban Gomez	19	13	31.58%
Lubbock TX	David Kinnison	18	7	61.11%
Lubbock TX	Edgar Hernandez	10	4	60.00%
Lubbock TX	Judie Stunkard	17	14	17.65%
Lubbock TX	Emily Breisch	16	8	50.00%
Lubbock TX	Brandon Howard	19	12	36.84%
Lubbock TX	Dustin Dooley	18	11	38.89%
Lubbock TX	Tyesha Duke	14	4	71.43%
Lubbock TX	Drichia Williams	15	5	66.67%
Lubbock TX	Frances Kollman	15	7	53.33%
Lubbock TX	Samuel Soto	17	7	58.82%
Lubbock TX	John Simek	6	1	83.33%
Lubbock TX	Benjamin Nickerson II	19	12	36.84%
Lubbock TX	Anthony Perez	16	7	56.25%
Lubbock TX	Crystal Benavidez	22	9	59.09%
Lubbock TX	Thomas Cundiff	5	1	80.00%
Lubbock TX	Loretta Torres	18	7	61.11%
Lubbock TX	Cynthia Breisch	20	13	35.00%
Lubbock TX	Criselda Fernandez	4	2	50.00%
Lubbock TX	Dylan Ledbetter	14	6	57.14%
Lubbock TX	Andrea Garcia	13	10	23.08%
Lubbock TX	Johnny Rodriguez	6	2	66.67%
Manila/Sta. Cruz Philippines	Haidi San Valentin	22	9	59.09%
Manila/Sta. Cruz Philippines	Ramphel Ezra Baclig	15	2	86.67%
Manila/Sta. Cruz Philippines	Patrick Lourence Mesias	11	5	54.55%
Manila/Sta. Cruz Philippines	Marishayne Rivera	12	2	83.33%
Manila/Sta. Cruz Philippines	James Ardin Aquino	16	2	87.50%
Manila/Sta. Cruz Philippines	Raymund Froilan Sim	16	7	56.25%
Manila/Sta. Cruz Philippines	Erika Rivera	14	4	71.43%
Manila/Sta. Cruz Philippines	Editha Bertucio	15	7	53.33%
Manila/Sta. Cruz Philippines	Astrid Frances Laureano	15	4	73.33%
Manila/Sta. Cruz Philippines	Elisa C Capistrano	11	3	72.73%
Manila/Sta. Cruz Philippines	Ethelbert Chang	40	1	97.50%
Manila/Sta. Cruz Philippines	Glenn Michael Angeles	21	4	80.95%
Manila/Sta. Cruz Philippines	Marion Michael Besino	11	7	36.36%
Manila/Sta. Cruz Philippines	Dennis Gervacio	15	2	86.67%
Manila/Sta. Cruz Philippines	Hendrix Poblete	15	2	86.67%
Manila/Sta. Cruz Philippines	Maricar Angeles	16	1	93.75%
Manila/Sta. Cruz Philippines	Edmundo Natividad	39	2	94.87%
Manila/Sta. Cruz Philippines	Ronaldo Mack	17	5	70.59%
Manila/Sta. Cruz Philippines	Raymond Anthony Papera	16	3	81.25%
Manila/Sta. Cruz Philippines	Charisse Monica Baer	18	5	72.22%
Manila/Sta. Cruz Philippines	Miguel Santos	16	10	37.50%
Manila/Sta. Cruz Philippines	Daniel Olardo	21	15	28.57%
Manila/Sta. Cruz Philippines	Judeo Pagarao	7	0	100.00%
Manila/Sta. Cruz Philippines	Jhon Alfin Panganiban	10	1	90.00%
Manila/Sta. Cruz Philippines	Mark Joseph Pangan	12	4	66.67%
Manila/Sta. Cruz Philippines	Rameses King	21	1	95.24%
Manila/Sta. Cruz Philippines	Emil Martin	2	0	100.00%
Manila/Sta. Cruz Philippines	Ellen Lacerna	15	2	86.67%
Manila/Sta. Cruz Philippines	Gilmore Demdam	4	0	100.00%
Manila/Sta. Cruz Philippines	Michael Joshua Casas	19	4	78.95%
Manila/Sta. Cruz Philippines	Sheryll Lyn Lai	3	1	66.67%
Manila/Sta. Cruz Philippines	Geraldine Trinidad	1	0	100.00%
Pasig City Phil (Robinsons)	Karla Jane Go	16	11	31.25%
Pasig City Phil (Robinsons)	Paula Czarina Bumatayo	20	13	35.00%
Pasig City Phil (Robinsons)	Brian Pascual	19	0	100.00%
Pasig City Phil (Robinsons)	Ma. Elena dela Peña	15	10	33.33%
Pasig City Phil (Robinsons)	Richard Michael Columbretis	14	12	14.29%
Pasig City Phil (Robinsons)	Noriel Tongol	15	5	66.67%
Pasig City Phil (Robinsons)	Frederick Paiste	11	6	45.45%
Pasig City Phil (Robinsons)	Joanna Paula Enage	13	8	38.46%
Pasig City Phil (Robinsons)	Minerva Gotay	17	10	41.18%
Pasig City Phil (Robinsons)	Razel John Paduga	11	1	90.91%
Pasig City Phil (Robinsons)	Mayleene Felina Estoque	17	6	64.71%
Pasig City Phil (Robinsons)	Cristobal Oraza	13	4	69.23%
Pasig City Phil (Robinsons)	Roma Abestilla	10	4	60.00%
Pasig City Phil (Robinsons)	Eriberto Garcia Jr.	15	9	40.00%
Pasig City Phil (Robinsons)	Edmer Uy	20	6	70.00%
Pasig City Phil (Robinsons)	Rochelle Zapanta	14	7	50.00%
Pasig City Phil (Robinsons)	Joy Martinez	13	6	53.85%
Pasig City Phil (Robinsons)	Marco Angelo de Luna	13	9	30.77%
Pasig City Phil (Robinsons)	Jayr David	11	8	27.27%
Pasig City Phil (Robinsons)	Anna Marie Yanguas	11	6	45.45%
Pasig City Phil (Robinsons)	May Lynn Tan	14	9	35.71%
Pasig City Phil (Robinsons)	Mary Grace Torres	12	8	33.33%
Pasig City Phil (Robinsons)	Veronica Liwanagan	12	7	41.67%
Pasig City Phil (Robinsons)	Paolo James Canlas	10	8	20.00%
Pasig City Phil (Robinsons)	Rochelle Acuavera	11	8	27.27%
Pasig City Phil (Robinsons)	Khristine Anne Albis	10	5	50.00%
Pasig City Phil (Robinsons)	Bryan Diaz	12	5	58.33%
Pasig City Phil (Robinsons)	John Michael Sibug	7	5	28.57%
Pasig City Phil (Robinsons)	Mark Jason Manubay	11	10	9.09%
Manila/Sta. Cruz Philippines	Jearyl Ann Paradero	2	0	100.00%
St. John's Newfound (Torbay)	Ann Turner-Kenworthy	15	7	53.33%
St. John's Newfound (Torbay)	Brian Janes	9	0	100.00%
St. John's Newfound (Torbay)	Scott Kavanagh	5	1	80.00%
St. John's Newfound (Torbay)	Rodney Skanes	7	7	0.00%
St. John's Newfound (Torbay)	Cory Legge	6	1	83.33%
St. John's Newfound (Torbay)	Craig Chaulk	3	0	100.00%
St. John's Newfound (Torbay)	Lois Rideout	12	1	91.67%
St. John's Newfound (Torbay)	William McGrath	12	1	91.67%
St. John's Newfound (Torbay)	Barbara Osmond	14	5	64.29%
St. John's Newfound (Torbay)	Dean Shears	6	2	66.67%
Tucson AZ (Business)	Michael Phibbs	23	9	60.87%
Tucson AZ (Business)	Cynthia Ryan	16	2	87.50%
Tucson AZ (Business)	David Santillano	13	2	84.62%
Tucson AZ (Business)	Robert Rickert	14	3	78.57%
Tucson AZ (Business)	Jacquelyn Williams	8	4	50.00%
Tucson AZ (Business)	Desiree Navarro	15	1	93.33%
Tucson AZ (Business)	Holly House	21	10	52.38%
Tucson AZ (Business)	Michael Anderson	22	2	90.91%
Tucson AZ (Business)	Jennifer Mitchell	10	3	70.00%
Tucson AZ (Business)	Eric Jennings	21	11	47.62%
Tucson AZ (Business)	Ashley Hearin	16	3	81.25%
Tucson AZ (Business)	John Soto	15	1	93.33%
Tucson AZ (Business)	Zak Engelstad	18	10	44.44%
Tucson AZ (Business)	Kathryn Davis	16	3	81.25%
Tucson AZ (Business)	Rene Rivera	15	2	86.67%
Tucson AZ (Business)	Sandra Storm	19	6	68.42%
Tucson AZ (Business)	Cynthia Marquez	1	0	100.00%
Tucson AZ (Business)	Matthew Orman	1	1	0.00%
Work-at-Home Alberta	Tiffany Blair	21	7	66.67%
Work-at-Home NL	Christopher Bonnell	13	3	76.92%
Work-at-Home NL	Tanya Kane	3	2	33.33%
Work-at-Home NL	Stephanie Hawco	8	4	50.00%
Work-at-Home NL	Kerry Fitzgerald	4	0	100.00%
Home Agent Org Staff US Zone A	Dennis Bilow	1	0	100.00%

<COLGROUP><COL style="WIDTH: 154pt" span=9 width=205><TBODY>
</TBODY>

 

[ShaunKrane]

Also I have new criteria that has been requested to get the 1st Smallest, then 2nd Smallest and 3rd Smallest Scores in each sheet. Is there a way to attach a worksheeet instead of pasting items in the Thread.

 

[Andrew Poulsom]

Ties will be a problem.

 

[ShaunKrane]

Currently I am establishing a minimum criteria for # of Employees in the Agent Attendance Field so that may change. *Ties will be broken by close rate which will be another added column on this worksheet. </SPAN>


I know that there is a way to modify a min based on IF a Supervisor has a larger # of employess.
=IF(COUNTIF($E$3:$E$448,O4)>1,RANK(C4,$C$3:$C$448,1)/100,0)

 

[Andrew Poulsom]

If you want you can put your workbook on a share like Box.com and give a link to it in a reply.

 

[ShaunKrane]

Unfortunately Personal Network Storage and Backup websites are a blocked option from our Networks. So for now we would need to either use this resource or email.

 

[Andrew Poulsom]

Check your Private Messages.

 

[ShaunKrane]

As per our conversation I came up with this formula and it works perfectly to give me the smallest one.

=IFERROR(INDEX($B$2:$B$449,MATCH(TRUE,SMALL(IF($A$2:$A$449=N2,$L$2:$L$449),1)=(($A$2:$A$449=N2)*($L$2:$L$449)),FALSE)),"")

If I wanted the 2nd smallest I just change the 1 in bold to a .

Thanks for your help.:


=IFERROR(INDEX($B$2:$B$449,MATCH(TRUE,SMALL(IF($A$2:$A$449=N2,$L$2:$L$449),1)=(($A$2:$A$449=N2)*($L$2:$L$449)),FALSE)),"")