Fill Series Number Based On text

[muhammad susanto]

hi all..

how to make series number for this case :
<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]data
[/TH]
[TH]my target
[/TH]
[/TR]
</thead><tbody> [TR]
[TD]aaa[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]aaa[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]ee[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]ggggg[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]ggggg[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]hhh[/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD]etc..[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


thanks in advance..

sst.

 

[rpaulson]

Cell B3 then fill down

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