Fill Series Number Based On Adjacent Cell or Column

[muhammad susanto]

hi all...

how to make fill series number based on adjacent column
this layout :
<style type="text/css">
table.tableizer-table {
font-size: 12px;
border: 1px solid #CCC ;
font-family: Arial, Helvetica, sans-serif;
}
.tableizer-table td {
padding: 4px;
margin: 3px;
border: 1px solid #CCC ;
}
.tableizer-table th {
background-color: #104E8B ;
color: #FFF ;
font-weight: bold;
}
</style>
<table class="tableizer-table">
<thead><tr class="tableizer-firstrow"><th>desired result</th><th>data (given)</th></tr></thead><tbody>
<tr><td>1</td><td>manggo</td></tr>
<tr><td>1</td><td>manggo</td></tr>
<tr><td>1</td><td>manggo</td></tr>
<tr><td>2</td><td>pie</td></tr>
<tr><td>3</td><td>bananas</td></tr>
<tr><td>3</td><td>bananas</td></tr>
<tr><td>4</td><td>coffe</td></tr>
<tr><td> </td><td>etc...</td></tr>
</tbody></table>

thank in advance for your helping..

.sst

 

[MickG]

Place a 1 in "A2" and the following in "A3" down

=IF(B3=B2,A2,A2+1)