Auto Numbering Repeated Values

[shlaxim]

I can't find a way to auto number and repeat numbering according to the repeated values in the other column like this:

[TABLE="width: 200"]
<tbody>[TR]
[TD]1
[/TD]
[TD]Mike
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]Mike
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]Mike
[/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD]John
[/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD]John
[/TD]
[/TR]
[TR]
[TD]3
[/TD]
[TD]Tony
[/TD]
[/TR]
[TR]
[TD]3
[/TD]
[TD]Tony
[/TD]
[/TR]
[TR]
[TD]3
[/TD]
[TD]Tony
[/TD]
[/TR]
</tbody>[/TABLE]

Please help. Thank you in advance.

 

[Fishboy]

I can't find a way to auto number and repeat numbering according to the repeated values in the other column like this:

[TABLE="width: 200"]
<tbody>[TR]
[TD]1[/TD]
[TD]Mike[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Mike[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Mike[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]John[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]John[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]Tony[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]Tony[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]Tony[/TD]
[/TR]
</tbody>[/TABLE]

Please help. Thank you in advance.

Hi shlaxim, welcome to the boards.

Assuming your names are in column B starting in B1, put a 1 in cell A1, then put the following formula in A2 and drag-fill down:

=IF(B2=B1,A1,A1+1)

 

[shlaxim]

Thank you so much Fishboy. It works Perfectly!!!

 

[Fishboy]

Thank you so much Fishboy. It works Perfectly!!!

Happy to help