Need to increment untill another value is found

[Stiino0]

Hello all,

Just new to the site but have been lurking posts for a long time now, really helpful stuff.

Here's my problem (I want it in a formula/macro):

I want to increment a value in a certain column B for example untill infinity or untill the value of column A changes. And then the value should restart at 1 (value can be text all of a sudden ex. 11A, 15A, 15B,...)

so example:

[TABLE="class: grid, width: 500, align: left"]
<tbody>[TR]
[TD]Column A[/TD]
[TD]Column B[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]2[/TD]
[/TR]
</tbody>[/TABLE]

I want to make it automated to that I can easily use a formula/macro to make +600 articles instantly correct.

Thanks in advance for any kind of help! If anymore info is needed, I'll be lurking my own post!

Kind regards,

Stiino0

 

[sheetspread]

Just noticed this, do you still need help?

 

[sheetspread]

That link doesn't seem to work