help with selecting the last column

[Dundee Lad]

i hope i have followed the instructions properly for the html maker.

I have the following table in excel, there will be many more rows. Each month the column will update to a new one. what I need is for the latest columns result to be shown in column P and always in column p. can anyone help me i am lost?
<!-- Please do not remove this header -->
<!-- Table easily created from Excel with ASAP Utilities (http://www.asap-utilities.com) -->
<table border="1" bordercolor="#C0C0C0" bordercolordark="#FFFFFF" cellspacing="0" cellpadding="2">
<tr>
<td valign="bottom"><font face="Tahoma" size="2"><nobr>Unit</nobr></font></td>
<td valign="bottom"><font face="Tahoma" size="2"><nobr>Department</nobr></font></td>
<td valign="bottom"><font face="Tahoma" size="2"><nobr>Code</nobr></font></td>
<td align="center" valign="bottom"><font face="Tahoma" size="2"><nobr>1</nobr></font></td>
<td align="center" valign="bottom"><font face="Tahoma" size="2"><nobr>2</nobr></font></td>
<td align="center" valign="bottom"><font face="Tahoma" size="2"><nobr>3</nobr></font></td>
<td align="center" valign="bottom"><font face="Tahoma" size="2"><nobr>4</nobr></font></td>
<td align="center" valign="bottom"><font face="Tahoma" size="2"><nobr>5</nobr></font></td>
<td align="center" valign="bottom"><font face="Tahoma" size="2"><nobr>6</nobr></font></td>
<td align="center" valign="bottom"><font face="Tahoma" size="2"><nobr>7</nobr></font></td>
<td align="center" valign="bottom"><font face="Tahoma" size="2"><nobr>8</nobr></font></td>
<td align="center" valign="bottom"><font face="Tahoma" size="2"><nobr>9</nobr></font></td>
<td align="center" valign="bottom"><font face="Tahoma" size="2"><nobr>10</nobr></font></td>
<td align="center" valign="bottom"><font face="Tahoma" size="2"><nobr>11</nobr></font></td>
<td align="center" valign="bottom"><font face="Tahoma" size="2"><nobr>12</nobr></font></td>
</tr>
<tr>
<td valign="bottom"><font face="Tahoma" size="2"><nobr>GFD</nobr></font></td>
<td valign="bottom"><font face="Tahoma" size="2"><nobr>GFD321</nobr></font></td>
<td valign="bottom"><font face="Tahoma" size="2"><nobr>GFD321BigTicket</nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>1</nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>42</nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
</tr>
</table>

 

[VoG]

In P2 try

=INDEX(A2:O2,MATCH(9.99999999999999E+307,A2:O2))

and filled-down.
<table style="border-collapse: collapse; width: 64px; height: 40px;" border="0" cellpadding="0" cellspacing="0"><col style="width: 48pt;" width="64"><col> <tbody><tr><td style="height: 15pt; width: 48pt;" align="right" height="20" width="64">
</td> </tr></tbody><tbody><tr style="height: 15pt;" height="20"></tr></tbody></table>

 

[stanleydgromjr]

Vog II,

Nicely done.


Dundee Lad,

In P2 try (copied down):
=INDEX(D2:O2,MATCH(9.99999999999999E+307,D2:O2))


Have a great day,
Stan

 

[Dundee Lad]

Thanks for your help it works perfectly!!