Excel for Football National League

aminexcel

Board Regular
Joined
May 2, 2009
Messages
63
in bellow table, assume that "A" to "R" in c and d columns are 18 club's names of a national league.

<table width="467" border="0" cellpadding="0" cellspacing="0"><colgroup><col style="mso-width-source:userset;mso-width-alt:2816;width:58pt" width="77"> <col style="mso-width-source:userset;mso-width-alt:3145;width:65pt" width="86"> <col style="mso-width-source:userset;mso-width-alt:3949; width:81pt" span="2" width="108"> <col style="mso-width-source:userset;mso-width-alt:1609; width:33pt" span="2" width="44"> </colgroup><tbody><tr style="height:15.0pt" height="20"> <td class="xl69" style="height:15.0pt;width:58pt" height="20" width="77">A</td> <td class="xl69" style="border-left:none;width:65pt" width="86">B</td> <td class="xl69" style="border-left:none;width:81pt" width="108">C</td> <td class="xl69" style="border-left:none;width:81pt" width="108">D</td> <td class="xl69" style="border-left:none;width:33pt" width="44">E</td> <td class="xl69" style="border-left:none;width:33pt" width="44">F</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl70" style="height:15.0pt;border-top:none" height="20">01</td> <td class="xl70" style="border-top:none;border-left:none">20110802</td> <td class="xl70" style="border-top:none;border-left:none">A</td> <td class="xl70" style="border-top:none;border-left:none">F</td> <td class="xl70" style="border-top:none;border-left:none">2</td> <td class="xl70" style="border-top:none;border-left:none">2</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl70" style="height:15.0pt;border-top:none" height="20">01</td> <td class="xl70" style="border-top:none;border-left:none">20110802</td> <td class="xl70" style="border-top:none;border-left:none">L</td> <td class="xl70" style="border-top:none;border-left:none">I</td> <td class="xl70" style="border-top:none;border-left:none">0</td> <td class="xl70" style="border-top:none;border-left:none">0</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl70" style="height:15.0pt;border-top:none" height="20">01</td> <td class="xl70" style="border-top:none;border-left:none">20110802</td> <td class="xl70" style="border-top:none;border-left:none">N</td> <td class="xl70" style="border-top:none;border-left:none">J</td> <td class="xl70" style="border-top:none;border-left:none">0</td> <td class="xl70" style="border-top:none;border-left:none">0</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl70" style="height:15.0pt;border-top:none" height="20">01</td> <td class="xl70" style="border-top:none;border-left:none">20110802</td> <td class="xl70" style="border-top:none;border-left:none">D</td> <td class="xl70" style="border-top:none;border-left:none">K</td> <td class="xl70" style="border-top:none;border-left:none">2</td> <td class="xl70" style="border-top:none;border-left:none">3</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl70" style="height:15.0pt;border-top:none" height="20">01</td> <td class="xl70" style="border-top:none;border-left:none">20110802</td> <td class="xl70" style="border-top:none;border-left:none">G</td> <td class="xl70" style="border-top:none;border-left:none">M</td> <td class="xl70" style="border-top:none;border-left:none">3</td> <td class="xl70" style="border-top:none;border-left:none">1</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl70" style="height:15.0pt;border-top:none" height="20">01</td> <td class="xl70" style="border-top:none;border-left:none">20110802</td> <td class="xl70" style="border-top:none;border-left:none">C</td> <td class="xl70" style="border-top:none;border-left:none">P</td> <td class="xl70" style="border-top:none;border-left:none">1</td> <td class="xl70" style="border-top:none;border-left:none">1</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl70" style="height:15.0pt;border-top:none" height="20">01</td> <td class="xl70" style="border-top:none;border-left:none">20110802</td> <td class="xl70" style="border-top:none;border-left:none">E</td> <td class="xl70" style="border-top:none;border-left:none">Q</td> <td class="xl70" style="border-top:none;border-left:none">0</td> <td class="xl70" style="border-top:none;border-left:none">0</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl70" style="height:15.0pt;border-top:none" height="20">01</td> <td class="xl70" style="border-top:none;border-left:none">20110802</td> <td class="xl70" style="border-top:none;border-left:none">O</td> <td class="xl70" style="border-top:none;border-left:none">R</td> <td class="xl70" style="border-top:none;border-left:none">0</td> <td class="xl70" style="border-top:none;border-left:none">0</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl70" style="height:15.0pt;border-top:none" height="20">01</td> <td class="xl70" style="border-top:none;border-left:none">20110803</td> <td class="xl70" style="border-top:none;border-left:none">H</td> <td class="xl70" style="border-top:none;border-left:none">B</td> <td class="xl70" style="border-top:none;border-left:none">1</td> <td class="xl70" style="border-top:none;border-left:none">1</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl70" style="height:15.0pt;border-top:none" height="20">02</td> <td class="xl70" style="border-top:none;border-left:none">20110807</td> <td class="xl70" style="border-top:none;border-left:none">I</td> <td class="xl70" style="border-top:none;border-left:none">C</td> <td class="xl70" style="border-top:none;border-left:none">2</td> <td class="xl70" style="border-top:none;border-left:none">1</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl70" style="height:15.0pt;border-top:none" height="20">02</td> <td class="xl70" style="border-top:none;border-left:none">20110807</td> <td class="xl70" style="border-top:none;border-left:none">F</td> <td class="xl70" style="border-top:none;border-left:none">D</td> <td class="xl70" style="border-top:none;border-left:none">0</td> <td class="xl70" style="border-top:none;border-left:none">1</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl70" style="height:15.0pt;border-top:none" height="20">02</td> <td class="xl70" style="border-top:none;border-left:none">20110807</td> <td class="xl70" style="border-top:none;border-left:none">P</td> <td class="xl70" style="border-top:none;border-left:none">A</td> <td class="xl70" style="border-top:none;border-left:none">0</td> <td class="xl70" style="border-top:none;border-left:none">0</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl70" style="height:15.0pt;border-top:none" height="20">02</td> <td class="xl70" style="border-top:none;border-left:none">20110807</td> <td class="xl70" style="border-top:none;border-left:none">J</td> <td class="xl70" style="border-top:none;border-left:none">G</td> <td class="xl70" style="border-top:none;border-left:none">1</td> <td class="xl70" style="border-top:none;border-left:none">1</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl70" style="height:15.0pt;border-top:none" height="20">02</td> <td class="xl70" style="border-top:none;border-left:none">20110807</td> <td class="xl70" style="border-top:none;border-left:none">M</td> <td class="xl70" style="border-top:none;border-left:none">L</td> <td class="xl70" style="border-top:none;border-left:none">0</td> <td class="xl70" style="border-top:none;border-left:none">1</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl70" style="height:15.0pt;border-top:none" height="20">02</td> <td class="xl70" style="border-top:none;border-left:none">20110808</td> <td class="xl70" style="border-top:none;border-left:none">B</td> <td class="xl70" style="border-top:none;border-left:none">E</td> <td class="xl70" style="border-top:none;border-left:none">1</td> <td class="xl70" style="border-top:none;border-left:none">0</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl70" style="height:15.0pt;border-top:none" height="20">02</td> <td class="xl70" style="border-top:none;border-left:none">20110808</td> <td class="xl70" style="border-top:none;border-left:none">K</td> <td class="xl70" style="border-top:none;border-left:none">H</td> <td class="xl70" style="border-top:none;border-left:none">0</td> <td class="xl70" style="border-top:none;border-left:none">0</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl70" style="height:15.0pt;border-top:none" height="20">02</td> <td class="xl70" style="border-top:none;border-left:none">20110808</td> <td class="xl70" style="border-top:none;border-left:none">R</td> <td class="xl70" style="border-top:none;border-left:none">N</td> <td class="xl70" style="border-top:none;border-left:none">3</td> <td class="xl70" style="border-top:none;border-left:none">2</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl70" style="height:15.0pt;border-top:none" height="20">02</td> <td class="xl70" style="border-top:none;border-left:none">20110808</td> <td class="xl70" style="border-top:none;border-left:none">Q</td> <td class="xl70" style="border-top:none;border-left:none">O</td> <td class="xl70" style="border-top:none;border-left:none">1</td> <td class="xl70" style="border-top:none;border-left:none">1</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl70" style="height:15.0pt;border-top:none" height="20">03</td> <td class="xl70" style="border-top:none;border-left:none">20110811</td> <td class="xl70" style="border-top:none;border-left:none">G</td> <td class="xl70" style="border-top:none;border-left:none">F</td> <td class="xl70" style="border-top:none;border-left:none">
</td> <td class="xl70" style="border-top:none;border-left:none">
</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl70" style="height:15.0pt;border-top:none" height="20">03</td> <td class="xl70" style="border-top:none;border-left:none">20110811</td> <td class="xl70" style="border-top:none;border-left:none">D</td> <td class="xl70" style="border-top:none;border-left:none">I</td> <td class="xl70" style="border-top:none;border-left:none">
</td> <td class="xl70" style="border-top:none;border-left:none">
</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl70" style="height:15.0pt;border-top:none" height="20">03</td> <td class="xl70" style="border-top:none;border-left:none">20110811</td> <td class="xl70" style="border-top:none;border-left:none">C</td> <td class="xl70" style="border-top:none;border-left:none">J</td> <td class="xl70" style="border-top:none;border-left:none">
</td> <td class="xl70" style="border-top:none;border-left:none">
</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl70" style="height:15.0pt;border-top:none" height="20">03</td> <td class="xl70" style="border-top:none;border-left:none">20110811</td> <td class="xl70" style="border-top:none;border-left:none">P</td> <td class="xl70" style="border-top:none;border-left:none">M</td> <td class="xl70" style="border-top:none;border-left:none">
</td> <td class="xl70" style="border-top:none;border-left:none">
</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl70" style="height:15.0pt;border-top:none" height="20">03</td> <td class="xl70" style="border-top:none;border-left:none">20110812</td> <td class="xl70" style="border-top:none;border-left:none">N</td> <td class="xl70" style="border-top:none;border-left:none">B</td> <td class="xl70" style="border-top:none;border-left:none">
</td> <td class="xl70" style="border-top:none;border-left:none">
</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl70" style="height:15.0pt;border-top:none" height="20">03</td> <td class="xl70" style="border-top:none;border-left:none">20110812</td> <td class="xl70" style="border-top:none;border-left:none">O</td> <td class="xl70" style="border-top:none;border-left:none">E</td> <td class="xl70" style="border-top:none;border-left:none">
</td> <td class="xl70" style="border-top:none;border-left:none">
</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl70" style="height:15.0pt;border-top:none" height="20">03</td> <td class="xl70" style="border-top:none;border-left:none">20110812</td> <td class="xl70" style="border-top:none;border-left:none">A</td> <td class="xl70" style="border-top:none;border-left:none">K</td> <td class="xl70" style="border-top:none;border-left:none">
</td> <td class="xl70" style="border-top:none;border-left:none">
</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl70" style="height:15.0pt;border-top:none" height="20">03</td> <td class="xl70" style="border-top:none;border-left:none">20110812</td> <td class="xl70" style="border-top:none;border-left:none">H</td> <td class="xl70" style="border-top:none;border-left:none">Q</td> <td class="xl70" style="border-top:none;border-left:none">
</td> <td class="xl70" style="border-top:none;border-left:none">
</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl70" style="height:15.0pt;border-top:none" height="20">03</td> <td class="xl70" style="border-top:none;border-left:none">20110812</td> <td class="xl70" style="border-top:none;border-left:none">L</td> <td class="xl70" style="border-top:none;border-left:none">R</td> <td class="xl70" style="border-top:none;border-left:none">
</td> <td class="xl70" style="border-top:none;border-left:none">
</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl70" style="height:15.0pt;border-top:none" height="20">04</td> <td class="xl70" style="border-top:none;border-left:none">20110816</td> <td class="xl70" style="border-top:none;border-left:none">M</td> <td class="xl70" style="border-top:none;border-left:none">C</td> <td class="xl70" style="border-top:none;border-left:none">
</td> <td class="xl70" style="border-top:none;border-left:none">
</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl70" style="height:15.0pt;border-top:none" height="20">04</td> <td class="xl70" style="border-top:none;border-left:none">20110816</td> <td class="xl70" style="border-top:none;border-left:none">Q</td> <td class="xl70" style="border-top:none;border-left:none">N</td> <td class="xl70" style="border-top:none;border-left:none">
</td> <td class="xl70" style="border-top:none;border-left:none">
</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl70" style="height:15.0pt;border-top:none" height="20">04</td> <td class="xl70" style="border-top:none;border-left:none">20110816</td> <td class="xl70" style="border-top:none;border-left:none">I</td> <td class="xl70" style="border-top:none;border-left:none">P</td> <td class="xl70" style="border-top:none;border-left:none">
</td> <td class="xl70" style="border-top:none;border-left:none">
</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl70" style="height:15.0pt;border-top:none" height="20">04</td> <td class="xl70" style="border-top:none;border-left:none">20110817</td> <td class="xl70" style="border-top:none;border-left:none">E</td> <td class="xl70" style="border-top:none;border-left:none">D</td> <td class="xl70" style="border-top:none;border-left:none">
</td> <td class="xl70" style="border-top:none;border-left:none">
</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl70" style="height:15.0pt;border-top:none" height="20">04</td> <td class="xl70" style="border-top:none;border-left:none">20110817</td> <td class="xl70" style="border-top:none;border-left:none">R</td> <td class="xl70" style="border-top:none;border-left:none">A</td> <td class="xl70" style="border-top:none;border-left:none">
</td> <td class="xl70" style="border-top:none;border-left:none">
</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl70" style="height:15.0pt;border-top:none" height="20">04</td> <td class="xl70" style="border-top:none;border-left:none">20110817</td> <td class="xl70" style="border-top:none;border-left:none">K</td> <td class="xl70" style="border-top:none;border-left:none">G</td> <td class="xl70" style="border-top:none;border-left:none">
</td> <td class="xl70" style="border-top:none;border-left:none">
</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl70" style="height:15.0pt;border-top:none" height="20">04</td> <td class="xl70" style="border-top:none;border-left:none">20110817</td> <td class="xl70" style="border-top:none;border-left:none">J</td> <td class="xl70" style="border-top:none;border-left:none">H</td> <td class="xl70" style="border-top:none;border-left:none">
</td> <td class="xl70" style="border-top:none;border-left:none">
</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl70" style="height:15.0pt;border-top:none" height="20">04</td> <td class="xl70" style="border-top:none;border-left:none">20110817</td> <td class="xl70" style="border-top:none;border-left:none">F</td> <td class="xl70" style="border-top:none;border-left:none">L</td> <td class="xl70" style="border-top:none;border-left:none">
</td> <td class="xl70" style="border-top:none;border-left:none">
</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl70" style="height:15.0pt;border-top:none" height="20">04</td> <td class="xl70" style="border-top:none;border-left:none">20110817</td> <td class="xl70" style="border-top:none;border-left:none">B</td> <td class="xl70" style="border-top:none;border-left:none">O</td> <td class="xl70" style="border-top:none;border-left:none">
</td> <td class="xl70" style="border-top:none;border-left:none">
</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl70" style="height:15.0pt;border-top:none" height="20">05</td> <td class="xl70" style="border-top:none;border-left:none">20110824</td> <td class="xl70" style="border-top:none;border-left:none">G</td> <td class="xl70" style="border-top:none;border-left:none">E</td> <td class="xl70" style="border-top:none;border-left:none">
</td> <td class="xl70" style="border-top:none;border-left:none">
</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl70" style="height:15.0pt;border-top:none" height="20">05</td> <td class="xl70" style="border-top:none;border-left:none">20110824</td> <td class="xl70" style="border-top:none;border-left:none">P</td> <td class="xl70" style="border-top:none;border-left:none">F</td> <td class="xl70" style="border-top:none;border-left:none">
</td> <td class="xl70" style="border-top:none;border-left:none">
</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl70" style="height:15.0pt;border-top:none" height="20">05</td> <td class="xl70" style="border-top:none;border-left:none">20110824</td> <td class="xl70" style="border-top:none;border-left:none">I</td> <td class="xl70" style="border-top:none;border-left:none">K</td> <td class="xl70" style="border-top:none;border-left:none">
</td> <td class="xl70" style="border-top:none;border-left:none">
</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl70" style="height:15.0pt;border-top:none" height="20">05</td> <td class="xl70" style="border-top:none;border-left:none">20110824</td> <td class="xl70" style="border-top:none;border-left:none">A</td> <td class="xl70" style="border-top:none;border-left:none">M</td> <td class="xl70" style="border-top:none;border-left:none">
</td> <td class="xl70" style="border-top:none;border-left:none">
</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl70" style="height:15.0pt;border-top:none" height="20">05</td> <td class="xl70" style="border-top:none;border-left:none">20110824</td> <td class="xl70" style="border-top:none;border-left:none">N</td> <td class="xl70" style="border-top:none;border-left:none">O</td> <td class="xl70" style="border-top:none;border-left:none">
</td> <td class="xl70" style="border-top:none;border-left:none">
</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl70" style="height:15.0pt;border-top:none" height="20">05</td> <td class="xl70" style="border-top:none;border-left:none">20110824</td> <td class="xl70" style="border-top:none;border-left:none">C</td> <td class="xl70" style="border-top:none;border-left:none">Q</td> <td class="xl70" style="border-top:none;border-left:none">
</td> <td class="xl70" style="border-top:none;border-left:none">
</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl70" style="height:15.0pt;border-top:none" height="20">05</td> <td class="xl70" style="border-top:none;border-left:none">20110824</td> <td class="xl70" style="border-top:none;border-left:none">H</td> <td class="xl70" style="border-top:none;border-left:none">R</td> <td class="xl70" style="border-top:none;border-left:none">
</td> <td class="xl70" style="border-top:none;border-left:none">
</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl70" style="height:15.0pt;border-top:none" height="20">05</td> <td class="xl70" style="border-top:none;border-left:none">20110825</td> <td class="xl70" style="border-top:none;border-left:none">L</td> <td class="xl70" style="border-top:none;border-left:none">B</td> <td class="xl70" style="border-top:none;border-left:none">
</td> <td class="xl70" style="border-top:none;border-left:none">
</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl70" style="height:15.0pt;border-top:none" height="20">05</td> <td class="xl70" style="border-top:none;border-left:none">20110825</td> <td class="xl70" style="border-top:none;border-left:none">D</td> <td class="xl70" style="border-top:none;border-left:none">J</td> <td class="xl70" style="border-top:none;border-left:none">
</td> <td class="xl70" style="border-top:none;border-left:none">
</td> </tr> </tbody></table>

i want a macro to have bellow table, that when i adding the result of a match (for week 3 and more) in E & F columns, it show the ranking of teams in it same this: (http://www.soccer-spain.com/ssdocs/table1.php)

<table width="512" border="0" cellpadding="0" cellspacing="0"><colgroup><col style="width:48pt" span="8" width="64"> </colgroup><tbody><tr style="height:15.0pt" height="20"> <td class="xl68" style="height:15.0pt;width:48pt" height="20" width="64">CLUB</td> <td class="xl67" style="border-left:none;width:48pt" width="64">Pld</td> <td class="xl67" style="border-left:none;width:48pt" width="64">Pts</td> <td class="xl67" style="border-left:none;width:48pt" width="64">W</td> <td class="xl67" style="border-left:none;width:48pt" width="64">D</td> <td class="xl67" style="border-left:none;width:48pt" width="64">L</td> <td class="xl67" style="border-left:none;width:48pt" width="64">F</td> <td class="xl67" style="border-left:none;width:48pt" width="64">A</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl67" style="height:15.0pt;border-top:none" height="20">A</td> <td class="xl69" style="border-top:none;border-left:none">
</td> <td class="xl69" style="border-top:none;border-left:none">
</td> <td class="xl69" style="border-top:none;border-left:none">
</td> <td class="xl69" style="border-top:none;border-left:none">
</td> <td class="xl69" style="border-top:none;border-left:none">
</td> <td class="xl69" style="border-top:none;border-left:none">
</td> <td class="xl69" style="border-top:none;border-left:none">
</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl67" style="height:15.0pt;border-top:none" height="20">B</td> <td class="xl69" style="border-top:none;border-left:none">
</td> <td class="xl69" style="border-top:none;border-left:none">
</td> <td class="xl69" style="border-top:none;border-left:none">
</td> <td class="xl69" style="border-top:none;border-left:none">
</td> <td class="xl69" style="border-top:none;border-left:none">
</td> <td class="xl69" style="border-top:none;border-left:none">
</td> <td class="xl69" style="border-top:none;border-left:none">
</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl67" style="height:15.0pt;border-top:none" height="20">C</td> <td class="xl69" style="border-top:none;border-left:none">
</td> <td class="xl69" style="border-top:none;border-left:none">
</td> <td class="xl69" style="border-top:none;border-left:none">
</td> <td class="xl69" style="border-top:none;border-left:none">
</td> <td class="xl69" style="border-top:none;border-left:none">
</td> <td class="xl69" style="border-top:none;border-left:none">
</td> <td class="xl69" style="border-top:none;border-left:none">
</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl67" style="height:15.0pt;border-top:none" height="20">D</td> <td class="xl69" style="border-top:none;border-left:none">
</td> <td class="xl69" style="border-top:none;border-left:none">
</td> <td class="xl69" style="border-top:none;border-left:none">
</td> <td class="xl69" style="border-top:none;border-left:none">
</td> <td class="xl69" style="border-top:none;border-left:none">
</td> <td class="xl69" style="border-top:none;border-left:none">
</td> <td class="xl69" style="border-top:none;border-left:none">
</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl67" style="height:15.0pt;border-top:none" height="20">E</td> <td class="xl69" style="border-top:none;border-left:none">
</td> <td class="xl70" style="border-top:none;border-left:none">
</td> <td class="xl69" style="border-top:none;border-left:none">
</td> <td class="xl69" style="border-top:none;border-left:none">
</td> <td class="xl69" style="border-top:none;border-left:none">
</td> <td class="xl69" style="border-top:none;border-left:none">
</td> <td class="xl69" style="border-top:none;border-left:none">
</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl67" style="height:15.0pt;border-top:none" height="20">F</td> <td class="xl69" style="border-top:none;border-left:none">
</td> <td class="xl69" style="border-top:none;border-left:none">
</td> <td class="xl69" style="border-top:none;border-left:none">
</td> <td class="xl69" style="border-top:none;border-left:none">
</td> <td class="xl69" style="border-top:none;border-left:none">
</td> <td class="xl69" style="border-top:none;border-left:none">
</td> <td class="xl69" style="border-top:none;border-left:none">
</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl67" style="height:15.0pt;border-top:none" height="20">G</td> <td class="xl69" style="border-top:none;border-left:none">
</td> <td class="xl69" style="border-top:none;border-left:none">
</td> <td class="xl69" style="border-top:none;border-left:none">
</td> <td class="xl69" style="border-top:none;border-left:none">
</td> <td class="xl69" style="border-top:none;border-left:none">
</td> <td class="xl69" style="border-top:none;border-left:none">
</td> <td class="xl69" style="border-top:none;border-left:none">
</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl67" style="height:15.0pt;border-top:none" height="20">H</td> <td class="xl69" style="border-top:none;border-left:none">
</td> <td class="xl69" style="border-top:none;border-left:none">
</td> <td class="xl69" style="border-top:none;border-left:none">
</td> <td class="xl69" style="border-top:none;border-left:none">
</td> <td class="xl69" style="border-top:none;border-left:none">
</td> <td class="xl69" style="border-top:none;border-left:none">
</td> <td class="xl69" style="border-top:none;border-left:none">
</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl67" style="height:15.0pt;border-top:none" height="20">I</td> <td class="xl69" style="border-top:none;border-left:none">
</td> <td class="xl69" style="border-top:none;border-left:none">
</td> <td class="xl69" style="border-top:none;border-left:none">
</td> <td class="xl69" style="border-top:none;border-left:none">
</td> <td class="xl69" style="border-top:none;border-left:none">
</td> <td class="xl69" style="border-top:none;border-left:none">
</td> <td class="xl69" style="border-top:none;border-left:none">
</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl67" style="height:15.0pt;border-top:none" height="20">J</td> <td class="xl69" style="border-top:none;border-left:none">
</td> <td class="xl69" style="border-top:none;border-left:none">
</td> <td class="xl69" style="border-top:none;border-left:none">
</td> <td class="xl69" style="border-top:none;border-left:none">
</td> <td class="xl69" style="border-top:none;border-left:none">
</td> <td class="xl69" style="border-top:none;border-left:none">
</td> <td class="xl69" style="border-top:none;border-left:none">
</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl67" style="height:15.0pt;border-top:none" height="20">K</td> <td class="xl69" style="border-top:none;border-left:none">
</td> <td class="xl69" style="border-top:none;border-left:none">
</td> <td class="xl69" style="border-top:none;border-left:none">
</td> <td class="xl69" style="border-top:none;border-left:none">
</td> <td class="xl69" style="border-top:none;border-left:none">
</td> <td class="xl69" style="border-top:none;border-left:none">
</td> <td class="xl69" style="border-top:none;border-left:none">
</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl67" style="height:15.0pt;border-top:none" height="20">L</td> <td class="xl69" style="border-top:none;border-left:none">
</td> <td class="xl69" style="border-top:none;border-left:none">
</td> <td class="xl69" style="border-top:none;border-left:none">
</td> <td class="xl69" style="border-top:none;border-left:none">
</td> <td class="xl69" style="border-top:none;border-left:none">
</td> <td class="xl69" style="border-top:none;border-left:none">
</td> <td class="xl69" style="border-top:none;border-left:none">
</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl67" style="height:15.0pt;border-top:none" height="20">M</td> <td class="xl69" style="border-top:none;border-left:none">
</td> <td class="xl69" style="border-top:none;border-left:none">
</td> <td class="xl69" style="border-top:none;border-left:none">
</td> <td class="xl69" style="border-top:none;border-left:none">
</td> <td class="xl69" style="border-top:none;border-left:none">
</td> <td class="xl69" style="border-top:none;border-left:none">
</td> <td class="xl69" style="border-top:none;border-left:none">
</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl67" style="height:15.0pt;border-top:none" height="20">N</td> <td class="xl69" style="border-top:none;border-left:none">
</td> <td class="xl69" style="border-top:none;border-left:none">
</td> <td class="xl69" style="border-top:none;border-left:none">
</td> <td class="xl69" style="border-top:none;border-left:none">
</td> <td class="xl69" style="border-top:none;border-left:none">
</td> <td class="xl69" style="border-top:none;border-left:none">
</td> <td class="xl69" style="border-top:none;border-left:none">
</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl67" style="height:15.0pt;border-top:none" height="20">O</td> <td class="xl69" style="border-top:none;border-left:none">
</td> <td class="xl69" style="border-top:none;border-left:none">
</td> <td class="xl69" style="border-top:none;border-left:none">
</td> <td class="xl69" style="border-top:none;border-left:none">
</td> <td class="xl69" style="border-top:none;border-left:none">
</td> <td class="xl69" style="border-top:none;border-left:none">
</td> <td class="xl69" style="border-top:none;border-left:none">
</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl67" style="height:15.0pt;border-top:none" height="20">P</td> <td class="xl69" style="border-top:none;border-left:none">
</td> <td class="xl69" style="border-top:none;border-left:none">
</td> <td class="xl69" style="border-top:none;border-left:none">
</td> <td class="xl69" style="border-top:none;border-left:none">
</td> <td class="xl69" style="border-top:none;border-left:none">
</td> <td class="xl69" style="border-top:none;border-left:none">
</td> <td class="xl69" style="border-top:none;border-left:none">
</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl67" style="height:15.0pt;border-top:none" height="20">Q</td> <td class="xl69" style="border-top:none;border-left:none">
</td> <td class="xl69" style="border-top:none;border-left:none">
</td> <td class="xl69" style="border-top:none;border-left:none">
</td> <td class="xl69" style="border-top:none;border-left:none">
</td> <td class="xl69" style="border-top:none;border-left:none">
</td> <td class="xl69" style="border-top:none;border-left:none">
</td> <td class="xl69" style="border-top:none;border-left:none">
</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl67" style="height:15.0pt;border-top:none" height="20">R</td> <td class="xl69" style="border-top:none;border-left:none">
</td> <td class="xl69" style="border-top:none;border-left:none">
</td> <td class="xl69" style="border-top:none;border-left:none">
</td> <td class="xl69" style="border-top:none;border-left:none">
</td> <td class="xl69" style="border-top:none;border-left:none">
</td> <td class="xl69" style="border-top:none;border-left:none">
</td> <td class="xl69" style="border-top:none;border-left:none">
</td> </tr> </tbody></table>

thanks a lot
 
Last edited:

Excel Facts

What did Pito Salas invent?
Pito Salas, working for Lotus, popularized what would become to be pivot tables. It was released as Lotus Improv in 1989.

Forum statistics

Threads
1,215,375
Messages
6,124,578
Members
449,174
Latest member
chandan4057

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top