Cleaning Data With Formulas?

[JM144]

I need to find a way to clean up a massive amount of data on a regular basis that has very few constant factors. I must find out how to do this with formulas.

The relevant data that I need to extract comes from a number of different groups of data. The groups are all organized with the following characteristics:

(ex. "A1) -The first cell (top left) in the group is a person's name
followed by an account number(the first three of which are
standard for all groups of data) and then some more
variable data
(ex. "A2:C?") -The following row(s) are grouped into three columns of data
that vary in the number of rows

Additional consideration: Sometimes a group of data is cut off at the end of
a page of output. The following page recreates
the name and account info heading followed by
the remainder of the relevant data.

I need to create a table that displays the name/account info as the row description, the remainder of the data in the name/account column (ex. "A2:A?")as the column headings, the second column ("B2:B?"), which is numerical in value, as the populating data, and exclude the third column.

My intention is to create a dynamic chart that only needs the raw data dropped in one worksheet and the formula(s) can organize the data on another sheet. I want to avoid the use of macros and pivot tables at all costs.

Is this type of formula possible?

I hope I have included enough pertinent information.

Thanks!

 

[RSXchin]

I think you should learn access. or macros.

Would you mind posting a sample of your data so we can work with it?

 

[JM144]

Thanks for the response. I'm learning slowly learning macros right now but I'm a beginner. I tried to re-create a what I deal with. It looks much cleaner here but I have done my best to include the major sticking points that I have had issues with. There are typically a random # of rows that contains text that needs to be ignored in between pages (I have not included this). Also, the Info 1, Info 2, etc... are completely random and should be on the same row as the name and account line. The 100 in the account # is the same on all groups of data. Any insight will be greatly appreciated!

<table width="222" border="0" cellpadding="0" cellspacing="0"><col style="width: 71pt;" width="94"> <col style="width: 48pt;" width="64" span="2"> <tbody><tr style="height: 15pt;" height="20"> <td style="height: 15pt; width: 71pt;" width="94" height="20">Current</td> <td style="width: 48pt;" width="64">
</td> <td style="width: 48pt;" width="64">
</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">#</td> <td>
</td> <td>
</td> </tr> <tr style="height: 15pt;" height="20"> <td colspan="2" style="height: 15pt;" height="20">Jon Smith 100433 Info 1</td> <td>
</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">Category 1</td> <td align="right">215</td> <td class="xl65" align="right">20%</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">Category 2</td> <td align="right">156</td> <td class="xl65" align="right">15%</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">Category 3</td> <td align="right">4</td> <td class="xl65" align="right">0%</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">Category 4</td> <td align="right">686</td> <td class="xl65" align="right">65%</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">
</td> <td>
</td> <td>
</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">
</td> <td>
</td> <td>
</td> </tr> <tr style="height: 15pt;" height="20"> <td colspan="2" style="height: 15pt;" height="20">Jane Doe 100789 Info 2</td> <td>
</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">Category 1</td> <td align="right">123</td> <td class="xl65" align="right">7%</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">Category 2</td> <td align="right">756</td> <td class="xl65" align="right">45%</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">Category 3</td> <td align="right">489</td> <td class="xl65" align="right">29%</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">Category 4</td> <td align="right">159</td> <td class="xl65" align="right">10%</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">Category 5</td> <td align="right">65</td> <td class="xl65" align="right">4%</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">Category 6</td> <td align="right">76</td> <td class="xl65" align="right">5%</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">
</td> <td>
</td> <td class="xl65">
</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">
</td> <td>
</td> <td>
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl66" colspan="2" style="height: 15pt;" height="20">Category Page 1</td> <td>
</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">##</td> <td>
</td> <td>
</td> </tr> <tr style="height: 15pt;" height="20"> <td colspan="2" style="height: 15pt;" height="20">Jane Doe 100789 Info 2</td> <td>
</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">Category 7</td> <td align="right">195</td> <td class="xl65" align="right">0%</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">
</td> <td>
</td> <td>
</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">
</td> <td>
</td> <td>
</td> </tr> <tr style="height: 15pt;" height="20"> <td colspan="2" style="height: 15pt;" height="20">Jon Doe 100671 Info 3</td> <td>
</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">Category 1</td> <td align="right">756</td> <td class="xl65" align="right">61%</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">Category4</td> <td align="right">19</td> <td class="xl65" align="right">2%</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">Category 7</td> <td align="right">456</td> <td class="xl65" align="right">37%</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">
</td> <td>
</td> <td>
</td> </tr> <tr style="height: 15pt;" height="20"> <td colspan="3" style="height: 15pt;" height="20">Fred Flintstone 100124 Info 4</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">Category 2</td> <td align="right">123</td> <td class="xl65" align="right">9%</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">Category 8</td> <td align="right">469</td> <td class="xl65" align="right">37%</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">Category 9</td> <td align="right">789</td> <td class="xl65" align="right">100%</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">
</td> <td>
</td> <td>
</td> </tr> <tr style="height: 15pt;" height="20"> <td colspan="3" style="height: 15pt;" height="20">Barney Rubble 100547 Info 5</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">Category 1</td> <td align="right">756</td> <td class="xl65" align="right">5%</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">Category 2</td> <td align="right">5671</td> <td class="xl65" align="right">38%</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">Category 4</td> <td align="right">1696</td> <td class="xl65" align="right">11%</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">Category 5</td> <td align="right">1894</td> <td class="xl65" align="right">13%</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">Category 7</td> <td align="right">4786</td> <td class="xl65" align="right">32%</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">Category 8</td> <td align="right">156</td> <td class="xl65" align="right">1%</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">Category 9</td> <td align="right">156</td> <td class="xl65" align="right">1%</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">
</td> <td>
</td> <td>
</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">
</td> <td>
</td> <td>
</td> </tr> <tr style="height: 15pt;" height="20"> <td colspan="2" style="height: 15pt;" height="20">Category Page 2</td> <td>
</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">##</td> <td>
</td> <td>
</td> </tr> <tr style="height: 15pt;" height="20"> <td colspan="3" style="height: 15pt;" height="20"> Wilma Flintstone 100457 Info 6</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">Category 1</td> <td align="right">453</td> <td class="xl65" align="right">5%</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">Category 3</td> <td align="right">789</td> <td class="xl65" align="right">9%</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">Category 4</td> <td align="right">6456</td> <td class="xl65" align="right">75%</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">Category 7</td> <td align="right">167</td> <td class="xl65" align="right">2%</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">Category 8</td> <td align="right">786</td> <td class="xl65" align="right">9%</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">
</td> <td>
</td> <td>
</td> </tr> <tr style="height: 15pt;" height="20"> <td colspan="3" style="height: 15pt;" height="20">Betty Rubble 100671 Info 7</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">Category 5</td> <td align="right">5123</td> <td class="xl65" align="right">100%</td> </tr> </tbody></table>



<table width="222" border="0" cellpadding="0" cellspacing="0"><col style="width: 71pt;" width="94"> <col style="width: 48pt;" width="64" span="2"> <tbody><tr style="height: 15pt;" height="20"> <td style="height: 15pt; width: 71pt;" width="94" height="20"> <table width="222" border="0" cellpadding="0" cellspacing="0"><col style="width: 71pt;" width="94"> <col style="width: 48pt;" width="64" span="2"> <tbody><tr style="height: 15pt;" height="20"> <td style="height: 15pt; width: 71pt;" width="94" height="20">
</td> <td style="width: 48pt;" width="64">
</td> <td style="width: 48pt;" width="64">
</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">
</td> <td>
</td> <td>
</td> </tr> <tr style="height: 15pt;" height="20"> <td colspan="2" style="height: 15pt;" height="20">
</td> <td>
</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">
</td> <td align="right">
</td> <td class="xl65" align="right">
</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">
</td> <td align="right">
</td> <td class="xl65" align="right">
</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">
</td> <td align="right">
</td> <td class="xl65" align="right">
</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">
</td> <td align="right">
</td> <td class="xl65" align="right">
</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">
</td> <td>
</td> <td>
</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">
</td> <td>
</td> <td>
</td> </tr> <tr style="height: 15pt;" height="20"> <td colspan="2" style="height: 15pt;" height="20">
</td> <td>
</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">
</td> <td align="right">
</td> <td class="xl65" align="right">
</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">
</td> <td align="right">
</td> <td class="xl65" align="right">
</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">
</td> <td align="right">
</td> <td class="xl65" align="right">
</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">
</td> <td align="right">
</td> <td class="xl65" align="right">
</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">
</td> <td align="right">
</td> <td class="xl65" align="right">
</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">
</td> <td align="right">
</td> <td class="xl65" align="right">
</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">
</td> <td>
</td> <td class="xl65">
</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">
</td> <td>
</td> <td>
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl66" colspan="2" style="height: 15pt;" height="20">
</td> <td>
</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">
</td> <td>
</td> <td>
</td> </tr> <tr style="height: 15pt;" height="20"> <td colspan="2" style="height: 15pt;" height="20">
</td> <td>
</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">
</td> <td align="right">
</td> <td class="xl65" align="right">
</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">
</td> <td>
</td> <td>
</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">
</td> <td>
</td> <td>
</td> </tr> <tr style="height: 15pt;" height="20"> <td colspan="2" style="height: 15pt;" height="20">
</td> <td>
</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">
</td> <td align="right">
</td> <td class="xl65" align="right">
</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">
</td> <td align="right">
</td> <td class="xl65" align="right">
</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">
</td> <td align="right">
</td> <td class="xl65" align="right">
</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">
</td> <td>
</td> <td>
</td> </tr> <tr style="height: 15pt;" height="20"> <td colspan="3" style="height: 15pt;" height="20">
</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">
</td> <td align="right">
</td> <td class="xl65" align="right">
</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">
</td> <td align="right">
</td> <td class="xl65" align="right">
</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">
</td> <td align="right">
</td> <td class="xl65" align="right">
</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">
</td> <td>
</td> <td>
</td> </tr> <tr style="height: 15pt;" height="20"> <td colspan="3" style="height: 15pt;" height="20">
</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">
</td> <td align="right">
</td> <td class="xl65" align="right">
</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">
</td> <td align="right">
</td> <td class="xl65" align="right">
</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">
</td> <td align="right">
</td> <td class="xl65" align="right">
</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">
</td> <td align="right">
</td> <td class="xl65" align="right">
</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">
</td> <td align="right">
</td> <td class="xl65" align="right">
</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">
</td> <td align="right">
</td> <td class="xl65" align="right">
</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">
</td> <td align="right">
</td> <td class="xl65" align="right">
</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">
</td> <td>
</td> <td>
</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">
</td> <td>
</td> <td>
</td> </tr> <tr style="height: 15pt;" height="20"> <td colspan="2" style="height: 15pt;" height="20">
</td> <td>
</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">
</td> <td>
</td> <td>
</td> </tr> <tr style="height: 15pt;" height="20"> <td colspan="3" style="height: 15pt;" height="20">
</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">
</td> <td align="right">
</td> <td class="xl65" align="right">
</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">
</td> <td align="right">
</td> <td class="xl65" align="right">
</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">
</td> <td align="right">
</td> <td class="xl65" align="right">
</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">
</td> <td align="right">
</td> <td class="xl65" align="right">
</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">
</td> <td align="right">
</td> <td class="xl65" align="right">
</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">
</td> <td>
</td> <td>
</td> </tr> <tr style="height: 15pt;" height="20"> <td colspan="3" style="height: 15pt;" height="20">
</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">
</td> <td>
</td> <td class="xl65" align="right">
</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">
</td> <td>
</td> <td>
</td> </tr> </tbody></table></td> <td style="width: 48pt;" width="64">
</td> <td style="width: 48pt;" width="64">
</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">
</td> <td>
</td> <td>
</td> </tr> <tr style="height: 15pt;" height="20"> <td colspan="3" style="height: 15pt;" height="20">
</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">
</td> <td align="right">
</td> <td class="xl63" align="right">
</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">
</td> <td align="right">
</td> <td class="xl63" align="right">
</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">
</td> <td align="right">
</td> <td class="xl63" align="right">
</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">
</td> <td align="right">
</td> <td class="xl63" align="right">
</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">
</td> <td>
</td> <td>
</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">
</td> <td>
</td> <td>
</td> </tr> <tr style="height: 15pt;" height="20"> <td colspan="3" style="height: 15pt;" height="20">
</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">
</td> <td align="right">
</td> <td class="xl63" align="right">
</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">
</td> <td align="right">
</td> <td class="xl63" align="right">
</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">
</td> <td align="right">
</td> <td class="xl63" align="right">
</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">
</td> <td align="right">
</td> <td class="xl63" align="right">
</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">
</td> <td align="right">
</td> <td class="xl63" align="right">
</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">
</td> <td align="right">
</td> <td class="xl63" align="right">
</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">
</td> <td>
</td> <td class="xl63">
</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">
</td> <td>
</td> <td>
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" colspan="2" style="height: 15pt;" height="20">
</td> <td>
</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">
</td> <td>
</td> <td>
</td> </tr> <tr style="height: 15pt;" height="20"> <td colspan="3" style="height: 15pt;" height="20">
</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">
</td> <td align="right">
</td> <td class="xl63" align="right">
</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">
</td> <td>
</td> <td>
</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">
</td> <td>
</td> <td>
</td> </tr> <tr style="height: 15pt;" height="20"> <td colspan="3" style="height: 15pt;" height="20">
</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">
</td> <td align="right">
</td> <td class="xl63" align="right">
</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">
</td> <td align="right">
</td> <td class="xl63" align="right">
</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">
</td> <td align="right">
</td> <td class="xl63" align="right">
</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">
</td> <td>
</td> <td>
</td> </tr> <tr style="height: 15pt;" height="20"> <td colspan="3" style="height: 15pt;" height="20">
</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">
</td> <td align="right">
</td> <td class="xl63" align="right">
</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">
</td> <td align="right">
</td> <td class="xl63" align="right">
</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">
</td> <td align="right">
</td> <td class="xl63" align="right">
</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">
</td> <td>
</td> <td>
</td> </tr> <tr style="height: 15pt;" height="20"> <td colspan="3" style="height: 15pt;" height="20">
</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">
</td> <td align="right">
</td> <td class="xl63" align="right">
</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">
</td> <td align="right">
</td> <td class="xl63" align="right">
</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">
</td> <td align="right">
</td> <td class="xl63" align="right">
</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">
</td> <td align="right">
</td> <td class="xl63" align="right">
</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">
</td> <td align="right">
</td> <td class="xl63" align="right">
</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">
</td> <td align="right">
</td> <td class="xl63" align="right">
</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">
</td> <td align="right">
</td> <td class="xl63" align="right">
</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">
</td> <td>
</td> <td>
</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">
</td> <td>
</td> <td>
</td> </tr> <tr style="height: 15pt;" height="20"> <td colspan="2" style="height: 15pt;" height="20">
</td> <td>
</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">
</td> <td>
</td> <td>
</td> </tr> <tr style="height: 15pt;" height="20"> <td colspan="3" style="height: 15pt;" height="20">
</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">
</td> <td align="right">
</td> <td class="xl63" align="right">
</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">
</td> <td align="right">
</td> <td class="xl63" align="right">
</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">
</td> <td align="right">
</td> <td class="xl63" align="right">
</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">
</td> <td align="right">
</td> <td class="xl63" align="right">
</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">
</td> <td align="right">
</td> <td class="xl63" align="right">
</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">
</td> <td>
</td> <td>
</td> </tr> <tr style="height: 15pt;" height="20"> <td colspan="3" style="height: 15pt;" height="20">
</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">
</td> <td>
</td> <td class="xl63" align="right">
</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">
</td> <td>
</td> <td>
</td> </tr> </tbody></table>

 

[RSXchin]

I'm afraid I don't quite understand what you want to do. Are you trying to re-organize your data?

 

[JM144]

Yes, I have a number of other formulas that rely on the formatting I have described. I want to avoid the use of macros in favor of formulas to avoid the necessity of refreshing.