Fill Series Number With Data Repeated

[muhammad susanto]

hi all...

how to fill series number this below :

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]expected result (fill series number)[/TD]
[TD]data[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]a[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]b[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]c[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]a[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]b[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]c[/TD]
[/TR]
[TR]
[TD]etc...[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

any help, will be appreciated..

m.susanto

 

[rpresas]

hi all...

how to fill series number this below :

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]expected result (fill series number)[/TD]
[TD]data[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]a[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]b[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]c[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]a[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]b[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]c[/TD]
[/TR]
[TR]
[TD]etc...[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

any help, will be appreciated..

m.susanto

Are you trying to get the result above?

 

[muhammad susanto]

i don't have idea?

 

[rpresas]

i don't have idea?

Are you trying to show 1a, 2a, 3a, etc.?

 

[muhammad susanto]

i want single formula, any body could help me out...

 

[bosco_yip]

A2, copy down :

Want this ??

=IF(B2="a",COUNTIF(B$2:B2,"a"),"")

or this ??

=COUNTIF(B$2:B2,"a")

 

[muhammad susanto]

=IF(B2="a",COUNTIF(B$2:B2,"a"),"")

that's i want, thanks bosco_yip

 

[bosco_yip]

=IF(B2="a",COUNTIF(B$2:B2,"a"),"")

that's i want, thanks bosco_yip

You're welcome.