sequential numbering

[esejnk]

Excel 2008 - Windows XP

I am trying to get sequential numbers in column B based off values in column A.
Here is an example of what I would like to see in column B.
<table style="border-collapse: collapse; width: 102pt;" width="136" border="0" cellpadding="0" cellspacing="0"><col style="width: 32pt;" width="43"> <col style="width: 32pt;" width="43"> <col style="width: 38pt;" width="50"> <tbody><tr style="height: 12pt;" height="16"> <td class="xl67" style="height: 12pt; width: 32pt;" width="43" height="16">A</td> <td class="xl67" style="width: 32pt;" width="43" align="right">B</td> <td class="xl67" style="width: 38pt;" width="50" align="right">N</td> </tr> <tr style="height: 12pt;" height="16"> <td class="xl68" style="height: 12pt;" height="16">10608</td> <td class="xl68" align="right">1</td> <td class="xl68" align="right">1</td> </tr> <tr style="height: 12pt;" height="16"> <td class="xl68" style="height: 12pt;" height="16">10615</td> <td class="xl68" align="right">1</td> <td class="xl68" align="right">2</td> </tr> <tr style="height: 12pt;" height="16"> <td class="xl68" style="height: 12pt;" height="16">10615</td> <td class="xl68" align="right">2</td> <td class="xl68" align="right">3</td> </tr> <tr style="height: 12pt;" height="16"> <td class="xl68" style="height: 12pt;" height="16">10615</td> <td class="xl68" align="right">3</td> <td class="xl68" align="right">4</td> </tr> <tr style="height: 12pt;" height="16"> <td class="xl68" style="height: 12pt;" height="16">10624</td> <td class="xl68" align="right">1</td> <td class="xl68" align="right">5</td> </tr> <tr style="height: 12pt;" height="16"> <td class="xl68" style="height: 12pt;" height="16">10629</td> <td class="xl68" align="right">1</td> <td class="xl68" align="right">6</td> </tr> <tr style="height: 12pt;" height="16"> <td class="xl68" style="height: 12pt;" height="16">10629</td> <td class="xl68" align="right">2</td> <td class="xl68" align="right">7</td> </tr> <tr style="height: 12pt;" height="16"> <td class="xl68" style="height: 12pt;" height="16">10629</td> <td class="xl68" align="right">3</td> <td class="xl68" align="right">8</td> </tr> <tr style="height: 12pt;" height="16"> <td class="xl68" style="height: 12pt;" height="16">10629</td> <td class="xl68" align="right">4</td> <td class="xl68" align="right">9</td> </tr> <tr style="height: 12pt;" height="16"> <td class="xl68" style="height: 12pt;" height="16">10629</td> <td class="xl68" align="right">5</td> <td class="xl68" align="right">10</td> </tr> <tr style="height: 12pt;" height="16"> <td class="xl68" style="height: 12pt;" height="16">10629</td> <td class="xl68" align="right">6</td> <td class="xl68" align="right">11</td> </tr> <tr style="height: 12pt;" height="16"> <td class="xl68" style="height: 12pt;" height="16">10629</td> <td class="xl68" align="right">7</td> <td class="xl68" align="right">12</td> </tr> <tr style="height: 12pt;" height="16"> <td class="xl69" style="height: 12pt;" height="16">10635</td> <td class="xl68" align="right">1</td> <td class="xl68" align="right">13</td> </tr> <tr style="height: 12pt;" height="16"> <td class="xl68" style="height: 12pt;" height="16">10635</td> <td class="xl68" align="right">2</td> <td class="xl68" align="right">14</td> </tr> </tbody></table>
I was able to get close to the desired results, but I'm not sure how to reset the count when the value changes in A.

I used this formula:
=IF($A3=$A4,$N3,$N$2)

For this result:
<table style="border-collapse: collapse; width: 126pt;" width="168" border="0" cellpadding="0" cellspacing="0"><col style="width: 42pt;" span="3" width="56"> <tbody><tr style="height: 12pt;" height="16"> <td class="xl67" style="height: 12pt; width: 42pt;" width="56" height="16">A</td> <td class="xl67" style="width: 42pt;" width="56" align="right">B</td> <td class="xl67" style="width: 42pt;" width="56" align="right">N</td> </tr> <tr style="height: 12pt;" height="16"> <td class="xl69" style="height: 12pt;" height="16">10608</td> <td class="xl69" align="right">1</td> <td class="xl69" align="right">1</td> </tr> <tr style="height: 12pt;" height="16"> <td class="xl69" style="height: 12pt;" height="16">10615</td> <td class="xl69" align="right">1</td> <td class="xl69" align="right">2</td> </tr> <tr style="height: 12pt;" height="16"> <td class="xl69" style="height: 12pt;" height="16">10615</td> <td class="xl69" align="right">2</td> <td class="xl69" align="right">3</td> </tr> <tr style="height: 12pt;" height="16"> <td class="xl69" style="height: 12pt;" height="16">10615</td> <td class="xl69" align="right">3</td> <td class="xl69" align="right">4</td> </tr> <tr style="height: 12pt;" height="16"> <td class="xl69" style="height: 12pt;" height="16">10624</td> <td class="xl69" align="right">1</td> <td class="xl69" align="right">5</td> </tr> <tr style="height: 12pt;" height="16"> <td class="xl69" style="height: 12pt;" height="16">10629</td> <td class="xl69" align="right">1</td> <td class="xl69" align="right">6</td> </tr> <tr style="height: 12pt;" height="16"> <td class="xl69" style="height: 12pt;" height="16">10629</td> <td class="xl69" align="right">6</td> <td class="xl69" align="right">7</td> </tr> <tr style="height: 12pt;" height="16"> <td class="xl69" style="height: 12pt;" height="16">10629</td> <td class="xl69" align="right">7</td> <td class="xl69" align="right">8</td> </tr> <tr style="height: 12pt;" height="16"> <td class="xl69" style="height: 12pt;" height="16">10629</td> <td class="xl69" align="right">8</td> <td class="xl69" align="right">9</td> </tr> <tr style="height: 12pt;" height="16"> <td class="xl69" style="height: 12pt;" height="16">10629</td> <td class="xl69" align="right">9</td> <td class="xl69" align="right">10</td> </tr> <tr style="height: 12pt;" height="16"> <td class="xl69" style="height: 12pt;" height="16">10629</td> <td class="xl69" align="right">10</td> <td class="xl69" align="right">11</td> </tr> <tr style="height: 12pt;" height="16"> <td class="xl69" style="height: 12pt;" height="16">10629</td> <td class="xl69" align="right">11</td> <td class="xl69" align="right">12</td> </tr> <tr style="height: 12pt;" height="16"> <td class="xl69" style="height: 12pt;" height="16">10635</td> <td class="xl69" align="right">1</td> <td class="xl69" align="right">13</td> </tr> <tr style="height: 12pt;" height="16"> <td class="xl69" style="height: 12pt;" height="16">10635</td> <td class="xl69" align="right">13</td> <td class="xl69" align="right">14</td> </tr> </tbody></table>

There has to be a better way....
Any help or direction is greatly appreciated.

 

[wongm003]

how about (assuming this is going in cell B4)...

=IF($A3=$A4,$B3+1,1)

 

[esejnk]

Perfect, thank you!