Rank select cells only from a column

[ExBeginner]

Hi all!

In the below example i need to only rank the topline (bold records) and ignore all the other values from the value column when ranking. The excel rank formula ranks "office" as 3 because "detached" (which is a row to be ignored when ranking) has a higher value. It should however be ranked 2 as illustrated below...

Can anyone help??

Example:

-- removed inline image ---

 

[ExBeginner]

example image didnt display

Second attempt:
<table border="0" cellpadding="0" cellspacing="0" width="370"><colgroup><col style="mso-width-source:userset;mso-width-alt:2560;width:53pt" width="70"> <col style="mso-width-source:userset;mso-width-alt:5485; width:113pt" span="2" width="150"> </colgroup><tbody><tr style="height:15.75pt" height="21"> <td class="xl69" style="height:15.75pt;width:53pt" align="left" height="21" width="70">Rank</td> <td class="xl70" style="width:113pt" align="left" width="150">Description</td> <td class="xl74" style="width:113pt" align="left" width="150">Value</td> </tr> <tr style="height:15.75pt" height="21"> <td class="xl71" style="height:15.75pt" height="21">1</td> <td class="xl66">House</td> <td class="xl75">5,000,000</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl72" style="height:15.0pt" height="20"> </td> <td class="xl67"> Detached</td> <td class="xl76">3,000,000</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl72" style="height:15.0pt" height="20"> </td> <td class="xl67"> Semi</td> <td class="xl76">1,000,000</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl72" style="height:15.0pt" height="20"> </td> <td class="xl67"> Terrace</td> <td class="xl76">1,000,000</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl71" style="height:15.0pt" height="20">2</td> <td class="xl66">Office</td> <td class="xl75">2,000,000</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl72" style="height:15.0pt" height="20"> </td> <td class="xl67"> 1st Floor</td> <td class="xl76">1,000,000</td> </tr> <tr style="height:15.75pt" height="21"> <td class="xl73" style="height:15.75pt" height="21"> </td> <td class="xl68"> 2nd Floor</td> <td class="xl77">1,000,000</td> </tr> </tbody></table>