Spreadsheet: 139299d1328180402-how-to-order-a-row-into-a-different-row-price-file-mahju
Sheet: Sheet2

 | JNJ UN Equity | NOVN VX Equity | PFE UN Equity | GSK LN Equity | MRK UN Equity | SAN FP Equity | ABT UN Equity | BMY UN Equity | AZN LN Equity | AMGN UQ Equity | UNH UN Equity | LLY UN Equity | MDT UN Equity | TEVA UQ Equity | ROG VX Equity
Date | Johnson & Johnson | Novartis | Pfizer | Glaxo | Merck | Sanofi | Abbott | Bristol-Myers | Astrazeneca | Amgen | Unitedhealth | Eli Lilly | Medtronic | Teva | Roche
2002-12-31 00:00:00 | 53.71 | 50.45 | 30.57 | 1192 | 53.579 | 58.25 | 37.4139 | 23.15 | 2220 | 48.34 | 20.875 | 63.5 | 45.6 | 19.305 | 96.35
2003-12-31 00:00:00 | 51.66 | 56.15 | 35.33 | 1280 | 46.2 | 59.7 | 43.5872 | 28.6 | 2680 | 61.8 | 29.09 | 70.33 | 48.61 | 28.355 | 124.75
2004-12-31 00:00:00 | 63.42 | 57.3 | 26.89 | 1222 | 32.14 | 58.8 | 46.65 | 25.62 | 1889 | 64.15 | 44.015 | 56.75 | 49.67 | 29.86 | 130.9
2005-12-30 00:00:00 | 60.1 | 69.05 | 23.32 | 1469 | 31.81 | 74 | 39.43 | 22.98 | 2829 | 78.86 | 62.14 | 56.59 | 57.57 | 43.01 | 197.3
2006-12-29 00:00:00 | 66.02 | 70.25 | 25.9 | 1344 | 43.6 | 69.95 | 48.71 | 26.32 | 2744 | 68.31 | 53.73 | 52.1 | 53.51 | 31.08 | 218.5
2007-12-31 00:00:00 | 66.7 | 62.1 | 22.73 | 1279 | 58.11 | 62.98 | 56.15 | 26.52 | 2164 | 46.44 | 58.2 | 53.39 | 50.27 | 46.48 | 195.6
2008-12-31 00:00:00 | 59.83 | 52.7 | 17.71 | 1284.5 | 30.4 | 45.4 | 53.37 | 23.25 | 2807 | 57.75 | 26.6 | 40.27 | 31.42 | 42.57 | 162.5
2009-12-31 00:00:00 | 64.41 | 56.5 | 18.19 | 1319.5 | 36.54 | 55.06 | 53.99 | 25.25 | 2910.5 | 56.57 | 30.48 | 35.71 | 43.98 | 56.18 | 175.8
2010-12-31 00:00:00 | 61.85 | 54.95 | 17.51 | 1240 | 36.04 | 47.85 | 47.91 | 26.48 | 2922 | 54.9 | 36.11 | 35.04 | 37.09 | 52.13 | 137
2011-12-30 00:00:00 | 65.58 | 53.7 | 21.64 | 1471.5 | 37.7 | 56.75 | 56.23 | 35.24 | 2975 | 64.21 | 50.68 | 41.56 | 38.25 | 40.36 | 159.2
Year | Return | Return | Return | Return | Return | Return | Return | Return | Return | Return | Return | Return | Return | Return | Return
2003 | -0.03816793893129777 | 0.1129831516352824 | 0.1557082106640497 | 0.0738255033557047 | -0.1377218686425652 | 0.02489270386266096 | 0.1650001737322226 | 0.2354211663066956 | 0.2072072072072073 | 0.2784443525031028 | 0.3935329341317366 | 0.1075590551181103 | 0.06600877192982457 | 0.4687904687904689 | 0.2947586922677738
2004 | 0.2276422764227644 | 0.02048085485307216 | -0.2388904613642796 | -0.04531249999999998 | -0.3043290043290043 | -0.01507537688442218 | 0.07026833565817481 | -0.1041958041958042 | -0.2951492537313433 | 0.03802588996763778 | 0.5130629082158817 | -0.193089719891938 | 0.02180621271343353 | 0.05307705871980239 | 0.04929859719438889
2005 | -0.05234941658782721 | 0.2050610820244327 | -0.1327631089624396 | 0.2021276595744681 | -0.01026757934038591 | 0.2585034013605443 | -0.1547695605573419 | -0.1030444964871194 | 0.4976177871889889 | 0.229306313328137 | 0.4117914347381575 | -0.002819383259911823 | 0.1590497282061607 | 0.4403884795713329 | 0.507257448433919
2006 | 0.09850249584026605 | 0.0173787110789283 | 0.1106346483704974 | -0.08509189925119132 | 0.3706381640993399 | -0.05472972972972967 | 0.2353537915292925 | 0.1453437771975632 | -0.03004595263343934 | -0.1337813847324372 | -0.1353395558416479 | -0.07934264004241032 | -0.07052284175786006 | -0.2773773541036968 | 0.1074505828687278
2007 | 0.01029990911844902 | -0.1160142348754448 | -0.1223938223938223 | -0.04836309523809523 | 0.3327981651376146 | -0.0996426018584704 | 0.1527407103264216 | 0.007598784194528863 | -0.2113702623906706 | -0.3201581027667985 | 0.08319374651032962 | 0.02476007677543191 | -0.06054943001308155 | 0.4954954954954955 | -0.1048054919908467
2008 | -0.1029985007496252 | -0.1513687600644122 | -0.2208534975802904 | 0.004300234558248572 | -0.4768542419549131 | -0.2791362337249921 | -0.04951024042742658 | -0.1233031674208145 | 0.2971349353049908 | 0.2435400516795867 | -0.5429553264604812 | -0.2457389024161828 | -0.3749751342749155 | -0.0841222030981067 | -0.1692229038854806
2009 | 0.07655022563931135 | 0.07210626185958247 | 0.02710333145115751 | 0.02724795640326971 | 0.2019736842105264 | 0.2127753303964759 | 0.01161701330335396 | 0.08602150537634401 | 0.03687210545065911 | -0.02043290043290047 | 0.1458646616541353 | -0.1132356592997269 | 0.3997453851050286 | 0.3197087150575522 | 0.0818461538461539
2010 | -0.039745381151995 | -0.02743362831858398 | -0.03738317757009346 | -0.06025009473285337 | -0.01368363437328957 | -0.1309480566654558 | -0.1126134469346176 | 0.04871287128712876 | 0.003951211132107835 | -0.02952094749867429 | 0.1847112860892388 | -0.01876225147017652 | -0.1566621191450658 | -0.07208971164115341 | -0.2207053469852105
2011 | 0.0603071948261924 | -0.02274795268425844 | 0.2358652198743574 | 0.1866935483870968 | 0.04605993340732528 | 0.1859979101358411 | 0.1736589438530578 | 0.3308157099697886 | 0.01813826146475006 | 0.1695810564663023 | 0.403489338133481 | 0.1860730593607307 | 0.03127527635481253 | -0.225781699597161 | 0.1620437956204379
Ranking
Year | Top 10 Performers |  |  |  |  |  |  |  |  |  | Bottom 5 Performers
2003 | 0.4687904687904689 | 0.3935329341317366 | 0.2947586922677738 | 0.2784443525031028 | 0.2354211663066956 | 0.2072072072072073 | 0.1650001737322226 | 0.1557082106640497 | 0.1129831516352824 | 0.1075590551181103 | 0.06600877192982457 | 0.1075590551181103 | 0.2947586922677738 | 0.3935329341317366 | 0.4687904687904689
2004 | 0.5130629082158817 | 0.2276422764227644 | 0.07026833565817481 | 0.05307705871980239 | 0.04929859719438889 | 0.03802588996763778 | 0.02180621271343353 | 0.02048085485307216 | -0.01507537688442218 | -0.04531249999999998 | -0.193089719891938 | 0.02180621271343353 | 0.04929859719438889 | 0.05307705871980239 | 0.5130629082158817
2005 | 0.507257448433919 | 0.4976177871889889 | 0.4403884795713329 | 0.4117914347381575 | 0.2585034013605443 | 0.229306313328137 | 0.2050610820244327 | 0.2021276595744681 | 0.1590497282061607 | -0.002819383259911823 | -0.002819383259911823 | 0.1590497282061607 | 0.4117914347381575 | 0.4403884795713329 | 0.507257448433919
2006 | 0.3706381640993399 | 0.2353537915292925 | 0.1453437771975632 | 0.1106346483704974 | 0.1074505828687278 | 0.09850249584026605 | 0.0173787110789283 | -0.03004595263343934 | -0.05472972972972967 | -0.07052284175786006 | -0.2773773541036968 | -0.1353395558416479 | -0.07934264004241032 | -0.07052284175786006 | 0.1074505828687278
2007 | 0.4954954954954955 | 0.3327981651376146 | 0.1527407103264216 | 0.08319374651032962 | 0.02476007677543191 | 0.01029990911844902 | 0.007598784194528863 | -0.04836309523809523 | -0.06054943001308155 | -0.0996426018584704 | -0.1048054919908467 | -0.06054943001308155 | 0.02476007677543191 | 0.08319374651032962 | 0.4954954954954955
2008 | 0.2971349353049908 | 0.2435400516795867 | 0.004300234558248572 | -0.04951024042742658 | -0.0841222030981067 | -0.1029985007496252 | -0.1233031674208145 | -0.1513687600644122 | -0.1692229038854806 | -0.2208534975802904 | -0.5429553264604812 | -0.3749751342749155 | -0.2457389024161828 | -0.1692229038854806 | -0.0841222030981067
2009 | 0.3997453851050286 | 0.3197087150575522 | 0.2127753303964759 | 0.2019736842105264 | 0.1458646616541353 | 0.08602150537634401 | 0.0818461538461539 | 0.07655022563931135 | 0.07210626185958247 | 0.03687210545065911 | -0.1132356592997269 | 0.0818461538461539 | 0.1458646616541353 | 0.3197087150575522 | 0.3997453851050286
2010 | 0.1847112860892388 | 0.04871287128712876 | 0.003951211132107835 | -0.01368363437328957 | -0.01876225147017652 | -0.02743362831858398 | -0.02952094749867429 | -0.03738317757009346 | -0.039745381151995 | -0.06025009473285337 | -0.2207053469852105 | -0.1566621191450658 | -0.07208971164115341 | -0.01876225147017652 | 0.1847112860892388
2011 | 0.403489338133481 | 0.3308157099697886 | 0.2358652198743574 | 0.1866935483870968 | 0.1860730593607307 | 0.1859979101358411 | 0.1736589438530578 | 0.1695810564663023 | 0.1620437956204379 | 0.0603071948261924 | -0.225781699597161 | 0.03127527635481253 | 0.1620437956204379 | 0.1860730593607307 | 0.403489338133481