Counting consecutive occurrences of a value

[kot.rav]

I have a data set in which I would like to number subsequent occurrences of the same value in the DBL_TwrID column. The set is sorted according to this column, so the plan is to give a value incrementing by 1 in the column next to it, which will return to one when the DBL_TwrID value changes (example in red)

[Admin]

You should be able to do this with Total after adding a new column of 1s.

total.transform (1.8 KB)

[kot.rav]

It worked, thank you for your help.