Sorting/Ranking/Match?

[Celticshadow]

Hi All

Please find below my request I trust you find this to be in order and I thank you all in advance.

Kind Regards

<table border="0" cellpadding="0" cellspacing="0" width="658"><colgroup><col style="width:48pt" span="3" width="64"> </colgroup><colgroup><col style="mso-width-source:userset;mso-width-alt:2596;width:53pt" width="71"> </colgroup><colgroup><col style="mso-width-source:userset;mso-width-alt:5083;width:104pt" width="139"> </colgroup><colgroup><col style="width:48pt" span="4" width="64"> </colgroup><tbody><tr style="height:12.75pt" height="17"><td class="xl67" style="height:12.75pt;width:48pt" height="17" width="64">FC</td><td class="xl67" style="width:48pt" width="64">FC Rank</td><td class="xl67" style="width:48pt" width="64">LTO</td><td class="xl67" style="width:53pt" width="71">LTO RANK</td><td class="xl67" style="width:104pt" width="139">REQUIRED RESULT</td><td class="xl67" style="width:48pt" width="64">
</td><td class="xl67" style="width:48pt" width="64">
</td><td class="xl67" style="width:48pt" width="64">
</td><td class="xl67" style="width:48pt" width="64">
</td></tr><tr style="height:12.75pt" height="17"><td class="xl67" style="height:12.75pt" height="17">5.00 </td><td class="xl68">5.00 </td><td class="xl67">1.00 </td><td class="xl67">1.00 </td><td class="xl67">1.00 </td><td class="xl67">
</td><td class="xl67">
</td><td class="xl67">
</td><td class="xl67">
</td></tr><tr style="height:12.75pt" height="17"><td class="xl67" style="height:12.75pt" height="17">3.00 </td><td class="xl68">3.00 </td><td class="xl67">2.00 </td><td class="xl67">2.00 </td><td class="xl67">2.00 </td><td class="xl67">
</td><td class="xl67">
</td><td class="xl67">
</td><td class="xl67">
</td></tr><tr style="height:12.75pt" height="17"><td class="xl67" style="height:12.75pt" height="17">1.00 </td><td class="xl68">1.00 </td><td class="xl67">6.00 </td><td class="xl67">6.00 </td><td class="xl67">6.00 </td><td class="xl67">
</td><td class="xl67">
</td><td class="xl67">
</td><td class="xl67">
</td></tr><tr style="height:12.75pt" height="17"><td class="xl67" style="height:12.75pt" height="17">4.00 </td><td class="xl68">4.00 </td><td class="xl67">7.00 </td><td class="xl67">7.00 </td><td class="xl67">7.00 </td><td class="xl67">
</td><td class="xl67">
</td><td class="xl67">
</td><td class="xl67">
</td></tr><tr style="height:12.75pt" height="17"><td class="xl67" style="height:12.75pt" height="17">9.00 </td><td class="xl67">8.00 </td><td class="xl67">0.00 </td><td class="xl67">9.00 </td><td class="xl67">
</td><td class="xl67">
</td><td class="xl67">
</td><td class="xl67">
</td><td class="xl67">
</td></tr><tr style="height:12.75pt" height="17"><td class="xl67" style="height:12.75pt" height="17">11.00 </td><td class="xl67">9.00 </td><td class="xl67">3.50 </td><td class="xl67">4.00 </td><td class="xl67">
</td><td class="xl67">
</td><td class="xl67">
</td><td class="xl67">
</td><td class="xl67">
</td></tr><tr style="height:12.75pt" height="17"><td class="xl67" style="height:12.75pt" height="17">2.50 </td><td class="xl68">2.00 </td><td class="xl67">5.00 </td><td class="xl67">5.00 </td><td class="xl67">5.00 </td><td class="xl67">
</td><td class="xl67">
</td><td class="xl67">
</td><td class="xl67">
</td></tr><tr style="height:12.75pt" height="17"><td class="xl67" style="height:12.75pt" height="17">8.00 </td><td class="xl67">7.00 </td><td class="xl67">9.00 </td><td class="xl67">8.00 </td><td class="xl67">
</td><td class="xl67">
</td><td class="xl67">
</td><td class="xl67">
</td><td class="xl67">
</td></tr><tr style="height:12.75pt" height="17"><td class="xl67" style="height:12.75pt" height="17">7.00 </td><td class="xl68">6.00 </td><td class="xl67">3.00 </td><td class="xl67">3.00 </td><td class="xl67">3.00 </td><td class="xl67">
</td><td class="xl67">
</td><td class="xl67">
</td><td class="xl67">
</td></tr><tr style="height:12.75pt" height="17"><td class="xl67" style="height:12.75pt" height="17">
</td><td class="xl67">
</td><td class="xl67">
</td><td class="xl67">
</td><td class="xl67">
</td><td class="xl67">
</td><td class="xl67">
</td><td class="xl67">
</td><td class="xl67">
</td></tr><tr style="height:12.75pt" height="17"><td class="xl69" colspan="9" style="height:12.75pt;mso-ignore:colspan" height="17">If   the lto rank is within the first six of the FC rank then I would like the LTO   figure to be shown in cloumn E.</td></tr> </tbody></table>

PS Why can I not show columns and rows in HTML editor?doh

 

[barry houdini]

Try this formula in E2 copied down

=IF(B2<=6,C2,"")

 

[Celticshadow]

Hi Barry Houdini

That works a treat. Many thanks for your help you have proved yourself a gent and a credit to the board once again.

Kind Regards