So, I have long sheet with multiple values by year. Need help extracting the top ten values by year using a formula. E.g. Year 2013 - Top ten values
02/12/2018 2018 Michal Olivo 148.71
02/09/2018 2018 Basilia Worthy 2.03
02/09/2018 2018 Madeleine Seabaugh 0.072
02/09/2018 2018 Phoebe Grennan -
02/09/2018 2018 Rosita Denman 6.38
02/09/2018 2018 Pok Seay -
02/09/2018 2018 Hershel Creamer -
02/09/2018 2018 Zulema Dewall -
02/09/2018 2018 Xiomara Fowkes 1.07
02/09/2018 2018 Neville Stillings 1.0
02/09/2018 2018 Eugena Tinney 47.63
02/08/2018 2018 Daniele Sottile -
02/08/2018 2018 Camila Deluca 158.16
02/07/2018 2018 Shanta Leday -
02/07/2018 2018 China Pearlman 59.92
02/07/2018 2018 Moriah Bigby 65.0
12/30/2017 2017 Shaunda Onorato 0.267
12/30/2017 2017 Jenelle Erskine -
12/29/2017 2017 Ines Killgore -
12/29/2017 2017 Carter Thibeault 36.82
12/29/2017 2017 Adena Huot 1.08
12/29/2017 2017 Ivonne Sturman -
12/29/2017 2017 Irina Maxey 13.83
12/29/2017 2017 Adelaide Denmark 0.942
12/28/2017 2017 Mariko Hausner 0.012
12/28/2017 2017 Nicol Toler -
12/28/2017 2017 Felecia Yandell 0.657
12/28/2017 2017 Lucas Faulks -
12/28/2017 2017 Lurline Dubberly 290.85
12/28/2017 2017 Werner Schuman -
12/28/2017 2017 Lai Masson 73.48
12/28/2017 2017 Celena Cid 0.935
12/28/2017 2017 Nestor Delahoussaye 4.62
12/28/2017 2017 Chanel Judon -
12/28/2017 2017 Arla Towle 6.08
12/27/2017 2017 Alesia Doggett 61.12
12/27/2017 2017 Luanne Hain 0.935
12/26/2017 2017 Cecil Mericle 78.06
12/26/2017 2017 Scarlett Nieman -
12/26/2017 2017 Virgilio Homer -
12/31/2016 2016 Elidia Shillings 24.68
12/31/2016 2016 Aldo Hunsinger 15.0
12/31/2016 2016 Lessie Boughton 5.0
12/31/2016 2016 Larisa Holmon -
12/31/2016 2016 Chester Vandoren 4.84
12/31/2016 2016 Starla Weymouth 0.096
12/31/2016 2016 Sherron Bower -
12/30/2016 2016 Bethann Privett -
12/30/2016 2016 Roselia Trask -
12/30/2016 2016 Shakia Rudnick -
12/30/2016 2016 Jeanne Sabb 185.19
12/30/2016 2016 Inger Olivieri 50.41
12/30/2016 2016 Tiffany Polite 0.25
12/30/2016 2016 Tod Waterbury 18.43
12/30/2016 2016 Miranda Ariola -
12/30/2016 2016 Annalisa Coffman 1.82
12/29/2016 2016 Rory Langston -
12/29/2016 2016 Shenna Biel 57.52
12/29/2016 2016 Donna Viviani 2.96
12/31/2015 2015 Kayla Kumm -
12/31/2015 2015 Apryl Aschenbrenner -
12/31/2015 2015 Joslyn Juckett -
12/31/2015 2015 Merissa Musgrave 16.73
12/31/2015 2015 Carla Casner 12.0
12/31/2015 2015 Ashely Arciniega -
12/31/2015 2015 Larue Laraway 0.491
12/31/2015 2015 Hyo Hellman 89.63
12/31/2015 2015 Lorrine Lampton -
12/31/2015 2015 Chasidy Consolini -
12/31/2015 2015 Dorathy Donlin -
12/30/2015 2015 Fredia Ferrara 125.0
12/30/2015 2015 Hester Hakes 0.295
12/30/2015 2015 Ciera Comerford 31.22
12/30/2015 2015 Emiko Ewan 2.75
12/30/2015 2015 Vinnie Victory 154.08
12/30/2015 2015 Georgina Greene -
12/30/2015 2015 Bambi Baines 30.82
12/29/2015 2015 Sanjuanita Servantes 0.303
12/29/2015 2015 Chere Collazo 0.3
Bookmarks