Easy excel question

[dgbezerra]

Hi There:

I have 4 columns: A, B, C, D

Column A: Has the stock ticker
Column B: Has the % stock return
Column C: My result (outcome using some formula), blank initially, not part of original data
Clumn D: My result (outcome using some formula), blank initially, not part of original data


I have 500 stocks or 500 rows:

How do I have excel spit out/ filter to me only the top 10 stocks ranked by Column B (stock return %)

Table details:

Column A Column B Column C Column D
Ticker Return (%) Result(Ticker) Result return(%
MSFT -3% XOM 5%
AAPL 1% AAPL 1%
IBM -4% IBM -4%
XOM 5% MSFT -3%

I have tried to use the rank function first, and then the VLOOKUP.
But only works if the % return column is already ranked on ascending order.

Any ideas?

Thanks for the help.

Diogo B

 

[Bamberg]

Hi Diogo B,

By using the rank function you should know, that your result can be contain dublicates. So you have to manipulate your data before you can use rank.

For instance:
<table border='1' cellspacing='0' cellpadding='2' valign='middle' colspan='8' style='font-family:Arial; color:#000000; background-color:#FFFFFF; font-size:10px; font-weight:normal; font-style:normal; '><colgroup><col width='28pt'><col width='60pt'><col width='60pt'><col width='40,5pt'><col width='31,5pt'><col width='51,75pt'><col width='65,25pt'><col width='75,75pt'></colgroup><tr style='background-color:#cacaca'><td> </td><td align='middle'>A</td><td align='middle'>B</td><td align='middle'>C</td><td align='middle'>D</td><td align='middle'>E</td><td align='middle'>F</td><td align='middle'>G</td></tr><tr><td style='background-color:#cacaca' align='middle'>1</td><td align='left' >Rank</td><td align='left' >Code</td><td align='left' >Row</td><td align='left' >Ticker</td><td align='left' >Return (%)</td><td align='left' >Result(Ticker)</td><td align='left' >Result return(%)</td></tr><tr><td style='background-color:#cacaca' align='middle'>2</td><td align='right' >12</td><td align='right' >-298</td><td align='right' >2</td><td align='left' >MSFT</td><td align='right' >-3,0%</td><td align='left' >XOM</td><td align='right' >5,0%</td></tr><tr><td style='background-color:#cacaca' align='middle'>3</td><td align='right' >8</td><td align='right' >103</td><td align='right' >3</td><td align='left' >AAPL</td><td align='right' >1,0%</td><td align='left' >AAPL</td><td align='right' >1,0%</td></tr><tr><td style='background-color:#cacaca' align='middle'>4</td><td align='right' >16</td><td align='right' >-396</td><td align='right' >4</td><td align='left' >IBM</td><td align='right' >-4,0%</td><td align='left' >IBM</td><td align='right' >-4,0%</td></tr><tr><td style='background-color:#cacaca' align='middle'>5</td><td align='right' >4</td><td align='right' >505</td><td align='right' >5</td><td align='left' >XOM</td><td align='right' >5,0%</td><td align='left' >MSFT</td><td align='right' >-3,0%</td></tr><tr><td style='background-color:#cacaca' align='middle'>6</td><td align='right' >11</td><td align='right' >-294</td><td align='right' >6</td><td align='left' >MSFT</td><td align='right' >-3,0%</td><td align='left' >XOM</td><td align='right' >5,0%</td></tr><tr><td style='background-color:#cacaca' align='middle'>7</td><td align='right' >7</td><td align='right' >107</td><td align='right' >7</td><td align='left' >AAPL</td><td align='right' >1,0%</td><td align='left' >AAPL</td><td align='right' >1,0%</td></tr><tr><td style='background-color:#cacaca' align='middle'>8</td><td align='right' >15</td><td align='right' >-392</td><td align='right' >8</td><td align='left' >IBM</td><td align='right' >-4,0%</td><td align='left' >IBM</td><td align='right' >-4,0%</td></tr><tr><td style='background-color:#cacaca' align='middle'>9</td><td align='right' >3</td><td align='right' >509</td><td align='right' >9</td><td align='left' >XOM</td><td align='right' >5,0%</td><td align='left' >MSFT</td><td align='right' >-3,0%</td></tr><tr><td style='background-color:#cacaca' align='middle'>10</td><td align='right' >10</td><td align='right' >-290</td><td align='right' >10</td><td align='left' >MSFT</td><td align='right' >-3,0%</td><td align='left' >XOM</td><td align='right' >5,0%</td></tr><tr><td style='background-color:#cacaca' align='middle'>11</td><td align='right' >6</td><td align='right' >111</td><td align='right' >11</td><td align='left' >AAPL</td><td align='right' >1,0%</td><td align='left' >AAPL</td><td align='right' >1,0%</td></tr><tr><td style='background-color:#cacaca' align='middle'>12</td><td align='right' >14</td><td align='right' >-388</td><td align='right' >12</td><td align='left' >IBM</td><td align='right' >-4,0%</td><td align='left' >IBM</td><td align='right' >-4,0%</td></tr><tr><td style='background-color:#cacaca' align='middle'>13</td><td align='right' >2</td><td align='right' >513</td><td align='right' >13</td><td align='left' >XOM</td><td align='right' >5,0%</td><td align='left' >MSFT</td><td align='right' >-3,0%</td></tr><tr><td style='background-color:#cacaca' align='middle'>14</td><td align='right' >9</td><td align='right' >-286</td><td align='right' >14</td><td align='left' >MSFT</td><td align='right' >-3,0%</td><td align='left' >XOM</td><td align='right' >5,0%</td></tr><tr><td style='background-color:#cacaca' align='middle'>15</td><td align='right' >5</td><td align='right' >115</td><td align='right' >15</td><td align='left' >AAPL</td><td align='right' >1,0%</td><td align='left' >AAPL</td><td align='right' >1,0%</td></tr><tr><td style='background-color:#cacaca' align='middle'>16</td><td align='right' >13</td><td align='right' >-384</td><td align='right' >16</td><td align='left' >IBM</td><td align='right' >-4,0%</td><td align='left' >IBM</td><td align='right' >-4,0%</td></tr><tr><td style='background-color:#cacaca' align='middle'>17</td><td align='right' >1</td><td align='right' >517</td><td align='right' >17</td><td align='left' >XOM</td><td align='right' >5,0%</td><td align='left' >MSFT</td><td align='right' >-3,0%</td></tr></table><br><table border='3' cellspacing='0' cellpadding='2' valign='middle' colspan='2' style='table-layout:auto; color:#000000; background-color:#FFFFFF; font-family:Arial; font-size:10px;'><colgroup><col width='40pt'><col></colgroup><tr style='background-color:#eeaaaa'><td>Cell</td><td>Formula</td></tr><tr><td>A2</td><td><Span style='color:#222222'>=RANK</Span><Span style='color:#0000DD'>(B2,B$2:B$17)</Span><Span style='color:#222222'></Span></td></tr><tr><td>B2</td><td><Span style='color:#222222'>=E2*10000+C2</Span></td></tr><tr><td>C2</td><td><Span style='color:#222222'>=ROW</Span><Span style='color:#0000DD'>()</Span><Span style='color:#222222'></Span></td></tr></table>

... the result table
<table border='1' cellspacing='0' cellpadding='2' valign='middle' colspan='4' style='font-family:Arial; color:#000000; background-color:#FFFFFF; font-size:10px; font-weight:normal; font-style:normal; '><colgroup><col width='28pt'><col width='60pt'><col width='60pt'><col width='40,5pt'></colgroup><tr style='background-color:#cacaca'><td> </td><td align='middle'>A</td><td align='middle'>B</td><td align='middle'>C</td></tr><tr><td style='background-color:#cacaca' align='middle'>21</td><td align='left' >Rank</td><td align='right' > </td><td align='right' > </td></tr><tr><td style='background-color:#cacaca' align='middle'>22</td><td align='right' >1</td><td align='left' >XOM</td><td align='right' >5,0%</td></tr><tr><td style='background-color:#cacaca' align='middle'>23</td><td align='right' >2</td><td align='left' >XOM</td><td align='right' >5,0%</td></tr><tr><td style='background-color:#cacaca' align='middle'>24</td><td align='right' >3</td><td align='left' >XOM</td><td align='right' >5,0%</td></tr><tr><td style='background-color:#cacaca' align='middle'>25</td><td align='right' >4</td><td align='left' >XOM</td><td align='right' >5,0%</td></tr><tr><td style='background-color:#cacaca' align='middle'>26</td><td align='right' >5</td><td align='left' >AAPL</td><td align='right' >1,0%</td></tr><tr><td style='background-color:#cacaca' align='middle'>27</td><td align='right' >6</td><td align='left' >AAPL</td><td align='right' >1,0%</td></tr><tr><td style='background-color:#cacaca' align='middle'>28</td><td align='right' >7</td><td align='left' >AAPL</td><td align='right' >1,0%</td></tr><tr><td style='background-color:#cacaca' align='middle'>29</td><td align='right' >8</td><td align='left' >AAPL</td><td align='right' >1,0%</td></tr><tr><td style='background-color:#cacaca' align='middle'>30</td><td align='right' >9</td><td align='left' >MSFT</td><td align='right' >-3,0%</td></tr><tr><td style='background-color:#cacaca' align='middle'>31</td><td align='right' >10</td><td align='left' >MSFT</td><td align='right' >-3,0%</td></tr></table><br><table border='3' cellspacing='0' cellpadding='2' valign='middle' colspan='2' style='color:#000000; background-color:#FFFFFF; font-family:Arial; font-size:10px;'><tr style='background-color:#eeaaee'><td>Name</td><td>Address</td></tr><tr><td>MyDatas</td><td>=Tabelle2!$A$2:$G$17</td></tr></table><br><table border='3' cellspacing='0' cellpadding='2' valign='middle' colspan='2' style='table-layout:auto; color:#000000; background-color:#FFFFFF; font-family:Arial; font-size:10px;'><colgroup><col width='40pt'><col></colgroup><tr style='background-color:#eeaaaa'><td>Cell</td><td>Formula</td></tr><tr><td>B22</td><td><Span style='color:#222222'>=VLOOKUP</Span><Span style='color:#0000DD'>(A22,MyDatas,4,FALSE)</Span><Span style='color:#222222'></Span></td></tr><tr><td>C22</td><td><Span style='color:#222222'>=VLOOKUP</Span><Span style='color:#0000DD'>(A22,MyDatas,5,FALSE)</Span><Span style='color:#222222'></Span></td></tr></table>

Best wishes
Gerd

 

[Aladin Akyurek]

Hi There:

I have 4 columns: A, B, C, D

Column A: Has the stock ticker
Column B: Has the % stock return
Column C: My result (outcome using some formula), blank initially, not part of original data
Clumn D: My result (outcome using some formula), blank initially, not part of original data


I have 500 stocks or 500 rows:

How do I have excel spit out/ filter to me only the top 10 stocks ranked by Column B (stock return %)

Table details:

Column A Column B Column C Column D
Ticker Return (%) Result(Ticker) Result return(%
MSFT -3% XOM 5%
AAPL 1% AAPL 1%
IBM -4% IBM -4%
XOM 5% MSFT -3%

I have tried to use the rank function first, and then the VLOOKUP.
But only works if the % return column is already ranked on ascending order.

Any ideas?

Thanks for the help.

Diogo B

<TABLE style="WIDTH: 296pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=394><COLGROUP><COL style="WIDTH: 57pt; mso-width-source: userset; mso-width-alt: 2702" width=76><COL style="WIDTH: 63pt; mso-width-source: userset; mso-width-alt: 2986" width=84><COL style="WIDTH: 81pt; mso-width-source: userset; mso-width-alt: 3840" width=108><COL style="WIDTH: 95pt; mso-width-source: userset; mso-width-alt: 4494" width=126><TBODY><TR style="HEIGHT: 14.4pt" height=19><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; WIDTH: 57pt; HEIGHT: 14.4pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl63 height=19 width=76>Ticker</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 63pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl63 width=84>Return (%)</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 81pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl63 width=108>Top N</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 95pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64 width=126 align=right>3</TD></TR><TR style="HEIGHT: 14.4pt" height=19><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 14.4pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl67 height=19>MSFT</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 63pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66 width=84 align=right>-3.00%</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl63>Top N Adjusted</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64 align=right>4</TD></TR><TR style="HEIGHT: 14.4pt" height=19><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 14.4pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl67 height=19>AAPL</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 63pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66 width=84 align=right>1.00%</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl63>Result Ticker</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl63>Result Return (%)</TD></TR><TR style="HEIGHT: 14.4pt" height=19><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 14.4pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl67 height=19>IBM</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 63pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66 width=84 align=right>-4.00%</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64>XOM</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64 align=right>0.05</TD></TR><TR style="HEIGHT: 14.4pt" height=19><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 14.4pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl67 height=19>XOM</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 63pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66 width=84 align=right>5.00%</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64>FAD</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64 align=right>0.05</TD></TR><TR style="HEIGHT: 14.4pt" height=19><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; WIDTH: 57pt; HEIGHT: 14.4pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 height=19 width=76>FAD</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 63pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66 width=84 align=right>5.00%</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64>AAPL</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64 align=right>0.01</TD></TR><TR style="HEIGHT: 14.4pt" height=19><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; WIDTH: 57pt; HEIGHT: 14.4pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 height=19 width=76>GAD</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 63pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66 width=84 align=right>1.00%</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64>GAD</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64 align=right>0.01</TD></TR><TR style="HEIGHT: 14.4pt" height=19><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; WIDTH: 57pt; HEIGHT: 14.4pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 height=19 width=76>JAD</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 63pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66 width=84 align=right>0.80%</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64> </TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64> </TD></TR><TR style="HEIGHT: 14.4pt" height=19><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; WIDTH: 57pt; HEIGHT: 14.4pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 height=19 width=76>LAD</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 63pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66 width=84 align=right>0.80%</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64> </TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64> </TD></TR><TR style="HEIGHT: 14.4pt" height=19><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; WIDTH: 57pt; HEIGHT: 14.4pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 height=19 width=76>KAD</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 63pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66 width=84 align=right>0.40%</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64> </TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64> </TD></TR><TR style="HEIGHT: 14.4pt" height=19><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; WIDTH: 57pt; HEIGHT: 14.4pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 height=19 width=76>NAD</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 63pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66 width=84 align=right>0.40%</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64> </TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64> </TD></TR></TBODY></TABLE>

A1:B11 houses a data sample with headers, incorporating the data from you exhibit.

D1: 3

which is the desired size of a Top N list (Adjust to 10 in your workbook).

D2, just enter:

=COUNTIF(B2:B11,">="&LARGE(B2:B11,D1))

D4, control+shift+enter, not just enter, and copy down:

=IF(N(D4),INDEX($A$2:$A$11,SMALL(IF($B$2:$B$11=$D4,
    ROW($A$2:$A$11)-ROW($A$2)+1),COUNTIF($D$4:D4,D4))),"")

E4, just enter and copy down:

=IF(ROWS($D$4:D4)<=$D$2,LARGE($B$2:$B$11,ROWS($D$4:D4)),"")