Hi All Members
i have this column in an sheet:
<table style="border-collapse: collapse; width: 126pt;" border="0" cellpadding="0" cellspacing="0" width="168"><col style="width: 54pt;" width="72"> <col style="width: 72pt;" width="96"> <tbody><tr style="height: 14.25pt;" height="19"> <td style="height: 14.25pt; width: 54pt;" align="center" height="19" width="72">
</td> <td class="xl65" style="width: 72pt;" align="center" width="96">A</td> </tr> <tr style="height: 14.25pt;" height="19"> <td class="xl67" style="height: 14.25pt;" align="center" height="19">1</td> <td class="xl66" style="border-top: medium none; border-left: medium none;" align="center">aminexcel</td> </tr> <tr style="height: 14.25pt;" height="19"> <td class="xl67" style="height: 14.25pt; border-top: medium none;" align="center" height="19">2</td> <td class="xl66" style="border-top: medium none; border-left: medium none;" align="center">stiglitzjoseph</td> </tr> <tr style="height: 14.25pt;" height="19"> <td class="xl67" style="height: 14.25pt; border-top: medium none;" align="center" height="19">3</td> <td class="xl66" style="border-top: medium none; border-left: medium none;" align="center">markhamilton</td> </tr> <tr style="height: 14.25pt;" height="19"> <td class="xl67" style="height: 14.25pt; border-top: medium none;" align="center" height="19">4</td> <td class="xl66" style="border-top: medium none; border-left: medium none;" align="center">hosseinobama</td> </tr> <tr style="height: 14.25pt;" height="19"> <td class="xl67" style="height: 14.25pt; border-top: medium none;" align="center" height="19">5</td> <td class="xl66" style="border-top: medium none; border-left: medium none;" align="center">excelamin</td> </tr> <tr style="height: 14.25pt;" height="19"> <td class="xl67" style="height: 14.25pt; border-top: medium none;" align="center" height="19">6</td> <td class="xl66" style="border-top: medium none; border-left: medium none;" align="center">hamiltonmark</td> </tr> <tr style="height: 14.25pt;" height="19"> <td class="xl67" style="height: 14.25pt; border-top: medium none;" align="center" height="19">7</td> <td class="xl66" style="border-top: medium none; border-left: medium none;" align="center">josephstiglitz</td> </tr> </tbody></table>
how can i recognize floating names with a formula or macro. i want to have this result
<table style="border-collapse: collapse; width: 180pt;" border="0" cellpadding="0" cellspacing="0" width="240"><col style="width: 54pt;" width="72"> <col style="width: 72pt;" width="96"> <col style="width: 54pt;" width="72"> <tbody><tr style="height: 14.25pt;" height="19"> <td style="height: 14.25pt; width: 54pt;" align="center" height="19" width="72">
</td> <td class="xl65" style="width: 72pt;" align="center" width="96">A</td> <td class="xl65" style="border-left: medium none; width: 54pt;" align="center" width="72">B</td> </tr> <tr style="height: 14.25pt;" height="19"> <td class="xl67" style="height: 14.25pt;" align="center" height="19">1</td> <td class="xl66" style="border-top: medium none; border-left: medium none;" align="center">aminexcel</td> <td class="xl67" style="border-top: medium none; border-left: medium none;" align="center">1</td> </tr> <tr style="height: 14.25pt;" height="19"> <td class="xl67" style="height: 14.25pt; border-top: medium none;" align="center" height="19">2</td> <td class="xl66" style="border-top: medium none; border-left: medium none;" align="center">excelamin</td> <td class="xl67" style="border-top: medium none; border-left: medium none;" align="center">1</td> </tr> <tr style="height: 14.25pt;" height="19"> <td class="xl67" style="height: 14.25pt; border-top: medium none;" align="center" height="19">3</td> <td class="xl66" style="border-top: medium none; border-left: medium none;" align="center">stiglitzjoseph</td> <td class="xl67" style="border-top: medium none; border-left: medium none;" align="center">2</td> </tr> <tr style="height: 14.25pt;" height="19"> <td class="xl67" style="height: 14.25pt; border-top: medium none;" align="center" height="19">4</td> <td class="xl66" style="border-top: medium none; border-left: medium none;" align="center">josephstiglitz</td> <td class="xl67" style="border-top: medium none; border-left: medium none;" align="center">2</td> </tr> <tr style="height: 14.25pt;" height="19"> <td class="xl67" style="height: 14.25pt; border-top: medium none;" align="center" height="19">5</td> <td class="xl66" style="border-top: medium none; border-left: medium none;" align="center">markhamilton</td> <td class="xl68" style="border-left: medium none;" align="center">3</td> </tr> <tr style="height: 14.25pt;" height="19"> <td class="xl67" style="height: 14.25pt; border-top: medium none;" align="center" height="19">6</td> <td class="xl66" style="border-top: medium none; border-left: medium none;" align="center">hamiltonmark</td> <td class="xl67" style="border-left: medium none;" align="center">3</td> </tr> <tr style="height: 14.25pt;" height="19"> <td class="xl67" style="height: 14.25pt; border-top: medium none;" align="center" height="19">7</td> <td class="xl66" style="border-top: medium none; border-left: medium none;" align="center">hosseinobama</td> <td class="xl67" style="border-top: medium none; border-left: medium none;" align="center">4</td> </tr> </tbody></table>
any idea?
i have this column in an sheet:
<table style="border-collapse: collapse; width: 126pt;" border="0" cellpadding="0" cellspacing="0" width="168"><col style="width: 54pt;" width="72"> <col style="width: 72pt;" width="96"> <tbody><tr style="height: 14.25pt;" height="19"> <td style="height: 14.25pt; width: 54pt;" align="center" height="19" width="72">
</td> <td class="xl65" style="width: 72pt;" align="center" width="96">A</td> </tr> <tr style="height: 14.25pt;" height="19"> <td class="xl67" style="height: 14.25pt;" align="center" height="19">1</td> <td class="xl66" style="border-top: medium none; border-left: medium none;" align="center">aminexcel</td> </tr> <tr style="height: 14.25pt;" height="19"> <td class="xl67" style="height: 14.25pt; border-top: medium none;" align="center" height="19">2</td> <td class="xl66" style="border-top: medium none; border-left: medium none;" align="center">stiglitzjoseph</td> </tr> <tr style="height: 14.25pt;" height="19"> <td class="xl67" style="height: 14.25pt; border-top: medium none;" align="center" height="19">3</td> <td class="xl66" style="border-top: medium none; border-left: medium none;" align="center">markhamilton</td> </tr> <tr style="height: 14.25pt;" height="19"> <td class="xl67" style="height: 14.25pt; border-top: medium none;" align="center" height="19">4</td> <td class="xl66" style="border-top: medium none; border-left: medium none;" align="center">hosseinobama</td> </tr> <tr style="height: 14.25pt;" height="19"> <td class="xl67" style="height: 14.25pt; border-top: medium none;" align="center" height="19">5</td> <td class="xl66" style="border-top: medium none; border-left: medium none;" align="center">excelamin</td> </tr> <tr style="height: 14.25pt;" height="19"> <td class="xl67" style="height: 14.25pt; border-top: medium none;" align="center" height="19">6</td> <td class="xl66" style="border-top: medium none; border-left: medium none;" align="center">hamiltonmark</td> </tr> <tr style="height: 14.25pt;" height="19"> <td class="xl67" style="height: 14.25pt; border-top: medium none;" align="center" height="19">7</td> <td class="xl66" style="border-top: medium none; border-left: medium none;" align="center">josephstiglitz</td> </tr> </tbody></table>
how can i recognize floating names with a formula or macro. i want to have this result
<table style="border-collapse: collapse; width: 180pt;" border="0" cellpadding="0" cellspacing="0" width="240"><col style="width: 54pt;" width="72"> <col style="width: 72pt;" width="96"> <col style="width: 54pt;" width="72"> <tbody><tr style="height: 14.25pt;" height="19"> <td style="height: 14.25pt; width: 54pt;" align="center" height="19" width="72">
</td> <td class="xl65" style="width: 72pt;" align="center" width="96">A</td> <td class="xl65" style="border-left: medium none; width: 54pt;" align="center" width="72">B</td> </tr> <tr style="height: 14.25pt;" height="19"> <td class="xl67" style="height: 14.25pt;" align="center" height="19">1</td> <td class="xl66" style="border-top: medium none; border-left: medium none;" align="center">aminexcel</td> <td class="xl67" style="border-top: medium none; border-left: medium none;" align="center">1</td> </tr> <tr style="height: 14.25pt;" height="19"> <td class="xl67" style="height: 14.25pt; border-top: medium none;" align="center" height="19">2</td> <td class="xl66" style="border-top: medium none; border-left: medium none;" align="center">excelamin</td> <td class="xl67" style="border-top: medium none; border-left: medium none;" align="center">1</td> </tr> <tr style="height: 14.25pt;" height="19"> <td class="xl67" style="height: 14.25pt; border-top: medium none;" align="center" height="19">3</td> <td class="xl66" style="border-top: medium none; border-left: medium none;" align="center">stiglitzjoseph</td> <td class="xl67" style="border-top: medium none; border-left: medium none;" align="center">2</td> </tr> <tr style="height: 14.25pt;" height="19"> <td class="xl67" style="height: 14.25pt; border-top: medium none;" align="center" height="19">4</td> <td class="xl66" style="border-top: medium none; border-left: medium none;" align="center">josephstiglitz</td> <td class="xl67" style="border-top: medium none; border-left: medium none;" align="center">2</td> </tr> <tr style="height: 14.25pt;" height="19"> <td class="xl67" style="height: 14.25pt; border-top: medium none;" align="center" height="19">5</td> <td class="xl66" style="border-top: medium none; border-left: medium none;" align="center">markhamilton</td> <td class="xl68" style="border-left: medium none;" align="center">3</td> </tr> <tr style="height: 14.25pt;" height="19"> <td class="xl67" style="height: 14.25pt; border-top: medium none;" align="center" height="19">6</td> <td class="xl66" style="border-top: medium none; border-left: medium none;" align="center">hamiltonmark</td> <td class="xl67" style="border-left: medium none;" align="center">3</td> </tr> <tr style="height: 14.25pt;" height="19"> <td class="xl67" style="height: 14.25pt; border-top: medium none;" align="center" height="19">7</td> <td class="xl66" style="border-top: medium none; border-left: medium none;" align="center">hosseinobama</td> <td class="xl67" style="border-top: medium none; border-left: medium none;" align="center">4</td> </tr> </tbody></table>
any idea?
