Fill Series 1,2,3,1,1

[muhammad susanto]

hi all....

how to make series like this :

[TABLE="class: tableizer-table"]
<tbody>[TR="class: tableizer-firstrow"]
[TH]data[/TH]
[TH]expected result[/TH]
[/TR]
[TR]
[TD]jack[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]cat[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]dog[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]etc..[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

note : without helper column

any helps...greatly appreciated...

susanto.

 

[JoeMo]

Why is B5 blank instead of a value of 4 like below:

Excel Workbook
	A	B
1	data	expected result
2	jack	1
3		2
4		3
5		4
6	cat	1
7	dog	1
Sheet5

 

[Rick Rothstein]

In addition to the question JoeMo asked in Message #2 (whose answer I would also be interested in), I have a question... what happens if there are more than 5 rows belonging to the name in Column A... does the series repeat (for example, 1, 2, 3, 1, 1, 1, 2, 3, 1, 1, 1, 2, 3, etc.)?